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

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.

TestData.xlsx

Transformation

Preparation

Accepted answers

FinnCharlton

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!

Update row 2.yxmd

All comments

FinnCharlton

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

Copy to row below.yxmd

ShankerV

Hi @ajanayak

Please find the expected output.

Many thanks

Shanker V

binu_acs

@ajanayak One way of doing this

Cross_Tab_011823.yxmd

Emmanuel_G

@ajanayak

Find in attachement the way of doing that.

Let me know if it works as well.

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

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

help180123.yxzp

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.

Test Data.xlsx

TestWF.yxmd

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.

TestWF180123.yxmd

TestWF180123.yxzp

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.

TestWF.yxmd

Test Data.xlsx

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335