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!
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!