Copy one row value to another row based on some condition (Based on some column value)

[ajanayak]

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.

[ajanayak]

Hello Finn,

I cross checked and seems like I followed the way you suggested, Please do one more time using my latest given data and Workflow. Please have a look and provide a solution, Thanks in advance, 

Learning new, Please help.

[FinnCharlton · Accepted solution]

Hi @ajanayak , this should work now, we needed to sort the "PO" and "Receive" rows into the correct order before the multi-row. Please note you are only transposing some columns, so only some will be copied. Also, you can use a union tool to add the rest of the data back on, just use the "False" anchor of the filter tool. Hope this helps!

[ajanayak]

Hello Sir,

I tried your approach by using my complete dataset but unfortunately there is some issue which is why my OP is not perfect, Please have a look as I am attaching my WF package here for your reference.

Many Thanks in advance.

[ajanayak]

Hello Shanker,

I also had a look into your WF but the moment I try to implement with the real dataset that does not give me appropriate OP, Please have a look as I have attached my dataset and WF here, Thanks in advance.

[ajanayak]

Many thanks Finn,

This works now, Have a good day.