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.

[FinnCharlton]

Hi @ajanayak , here is one way to achieve your output:

[ShankerV]

Hi @ajanayak 

Please find the expected output.

Many thanks

Shanker V

[binu_acs]

@ajanayak One way of doing this

[Emmanuel_G]

@ajanayak 

Find in attachement the way of doing that.

Let me know if it works as well.

[ShankerV]

Hi @ajanayak 

Step 1: Input

Step 2:

Step 3:

Many thanks

Shanker V

[ShankerV]

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

[BS_THE_ANALYST]

Hi! I think I might have done it? Can you have a check if it's doing what you want. Try attached workflow

[ajanayak]

Thanks Finn,

But I don't see the solution when I configure the way you have suggested, I have attached the workflow, Input and Output file, Please let me know where exactly I am doing wrong. 

Many thanks for your prompt response.

[FinnCharlton]

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.