How to make multiple duplicate rows

Suseendran

How to make multiple duplicate rows

Name List

1.Name
2.Ashok
3.Arjun
4.Anand
5.Anbu

Data Table

Data Amount Count

Date    PS     Cnt
Car      10       5
Bike     20      7
Train    30      9

i expected result is 

Name  Data  PS Cnt
Ashok  Car    10 5
Ashok  Bike   20 7
Ashok  Train  30 9
Arjun    Car   10 5
Arjun    Bike  20 7
Arjun    Train 30 9
Anand  Car   10 5
Anand  Bike  20 7
Anand  Train 30 9
Anbu    Car   10 5
Anbu    Bike  20 7
Anbu    Train 30 9

atcodedog05

Hi @Suseendran 

You can achieve this using the Append tool. Append tool does a cross join creating all combinations. Make sure to set the highlighted option as "Allow all append"

Workflow:

Hope this helps : )

append tool.yxmd