LAC not working in Data Prep

Q&A
, , ,
1

Hi, I’m trying to use a calculated field in order to get the maximum value by partition in data prep level (because i want to join the dataset to another dataset). But when i use MAX (LAC-A), it doesn’t seem working

image
image783×148 3.93 KB

and if i use maxOver({gms_usd}, [{warehouse_id}, {week_of_the_year}], PRE_AGG), the column shows “Unavailable”

If i create the calculation in Analysis, the LAC-A works.

Where’s the problem here?

Kind regards,
Jessica

2

Hi,

As I understand there is some issue in datatype of the field after the dataset join.
Secondly, revisit your joins too :slight_smile:

Regards,
Naveed Ali

3

Hi @jesstnto,
It’s been awhile since we last heard from you. Were you able to find a work around for your solution or did you have any additional questions?

If we do not hear back within the next 3 business days, I’ll go ahead and close this topic.

Thank you!

4

Hi @jesstnto,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!