Forum Discussion
Parent Split for two columns
Didn't help, but your idea manage to point me in the right direction. Got to work with a duplicate of the same table:
1st Table splits the Serial, 2nd Table splits the Heritage.
Create Index in both of them, and then Merge them together using the Indexes and comum column.
Thanks!
Hi ,
Select the Serial column.
Go to the Transform tab and click Split Column > By Delimiter:
Choose your delimiter (comma) and split into Rows.
Repeat the same steps for the Heritage column.
Hope this helps
This I already did, but the result for this is the middle table, and I need the 3rd one.
Basically for the first product, I need a row for A->1 B->2 and C->3. And not all the possibilities.
If for example I have 4 products, 10 Serials and 10 Heritages I would only need 40 rows, but your (and mine) method results in 400! (4x10x10)