Hello Team,
I need some urgent help as I got stuck in some issue, I have attached here the input file and also given the file output as well, Not sure how to get it done, Please help me and Thanks in advance.
One row data should be copied to another row based on some condition, In this exercise I have "SKU","Units" and "category", Based on that the data needs to be copied to "receive" Category from "PO" category, please help me. Let me know if you need more clarity on this requirement as well.
Solved! Go to Solution.
Hi @ajanayak
Step 4: Sort tool
Step 5:
IF [Category]="Receive"
THEN [Row-1:Value]
ELSE [Value]
ENDIF
Step 6:
IF [Category]="Receive" AND [Value]=0
THEN Null()
ELSE [Value]
ENDIF
Step 7:
Expected output post run
Many thanks
Shanker V
Hi @ajanayak , please check the configuration of the transpose tool, you need to set your "Category" field as a key column:
You will also need to group by this field in the CrossTab tool.