Hi, Can someone help me for this requirement . Sheet1 Input : Coder # Invoices A2B3C5 Sheet2 Input :Line1 Invoice1Line2Invoice2Line3Invoice3Line4Invoice4Line5Invoice5Line6Invoice6Line7Invoice7Line8Invoice8Line9Invoice9Line10Invoice10 And the output need to be : Sheet3 Output Line1 Invoice1ALine2Invoice2ALine3Invoice3BLine4Invoice4BLine5Invoice5BLine6Invoice6CLine7Invoice7CLine8Invoice8CLine9Invoice9CLine10Invoice10C Any help is appreciated .

Data mapping

Hi,

Can someone help me for this requirement .

Sheet1	Input :
Coder	# Invoices
A	2
B	3
C	5

Sheet2	Input :
Line1	Invoice1
Line2	Invoice2
Line3	Invoice3
Line4	Invoice4
Line5	Invoice5
Line6	Invoice6
Line7	Invoice7
Line8	Invoice8
Line9	Invoice9
Line10	Invoice10

And the output need to be :

Sheet3	Output
Line1	Invoice1	A
Line2	Invoice2	A
Line3	Invoice3	B
Line4	Invoice4	B
Line5	Invoice5	B
Line6	Invoice6	C
Line7	Invoice7	C
Line8	Invoice8	C
Line9	Invoice9	C
Line10	Invoice10	C

Any help is appreciated .

Datasets

Accepted answers

Felipe_Ribeir0

Hi @praneshsapmm

Please take a look at the attached workflow.

This solution is a worth try because it does not rely on the order of the rows of the inputs.

If the provided answer helped you to solve the problem/was correct, please accept it as a solution

Thanks.

DataMapping.yxmd

binu_acs

@praneshsapmm One way of doing this with the help of generate row tool

Invoice_0919.yxmd

All comments

Felipe_Ribeir0

Hi @praneshsapmm

Please take a look at the attached workflow.

This solution is a worth try because it does not rely on the order of the rows of the inputs.

If the provided answer helped you to solve the problem/was correct, please accept it as a solution

Thanks.

DataMapping.yxmd

binu_acs

@praneshsapmm One way of doing this with the help of generate row tool

Invoice_0919.yxmd

praneshsapmm

Hi @binu_acs ,

This worked perfectly . But there is slight change in requirement :

Currently the solution is working like this :

Invoice1	A
Invoice2	A
Invoice3	A
Invoice4	B
Invoice5	B
Invoice6	B
Invoice7	C
Invoice8	C
Invoice9	C

In it possible to make it :

Invoice1	A
Invoice2	B
Invoice3	C
Invoice4	A
Invoice5	B
Invoice6	C
Invoice7	A
Invoice8	B
Invoice9	C

Thanks.

binu_acs

@praneshsapmm I created a workflow based on your input data. You should update this workflow according to your real data. let me know if you need any assistance