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

[binuacs]

@Suseendran AppendField tool is able to do this

[atcodedog05 · Accepted solution]

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 : )

[Qiu]

@atcodedog05 
Glad to see you back.
happy new year to you!

[Suseendran]

Hi @atcodeog05 Really Thanks..Now it will work  

[atcodedog05]

@Qiu 

Happy to be back : )

Happy new year to you too 🙂 May it be filled with happiness and prosperity 😀

[Suseendran]

Wish u happy New year to you and your family 

Thanks a lot !!!!

[atcodedog05]

Happy to help : ) @Suseendran 

Happy new year to you 🙂 May it be filled with happiness and prosperity 😀