Generate Duplicate Value

GayatriPanigrahi

I have two data set like below and there is no common field for join. I need to generate duplicate value and produce output like below.

Any suggestion will be helpful.

Name

A

B

C

Team	Count
1	2
2	1
3	3

Output :

Name	Count
A	1
A	1
B	2
C	3
C	3
C	3

grossal

Hi @GayatriPanigrahi,

I think I got it!

What happens:

1) I join the Names based on the position

2) I generate the amount of columns based on your Count Column (with Generate Rows Tool)

3) Selecting the columns we want and renaming them

4) Fix the numbers with Multi-Row-Formula

Workflow attached. Let me know if this is what you are looking for.

Best

Alex

Edit: If the "Count" from your Example Output is just the team number, you can check the Team-Column in the Join tool and remove the Multi-Row-Formula, but I interpreted the Count as a different value and added a Multi-Row Formula to enumerate the Teams.

2020-03-29-generate-duplicate-value.yxmd