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)
Add a custom column that counts the number of commas in the Seri and Patri columns using the following formulas:
- SeriCount = List.Count(Text.Split([Seri], ","))
- PatriCount = List.Count(Text.Split([Patri], ","))
Expand the Seri and Patri columns using the "Expand" feature, selecting the "Use original column name as prefix" option.
This will create new columns for each value in the Seri and Patri 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!