Remove before split

[hnorgaar]

hi

I have query and will like to get some help to use split IF the data exists in another column, in this case if Field 2 to split by comma, but only with numbers that exists in Field 1. Field 2 is not important after the split and the split should only happens if the comma based values match from Field2 to Field 1

Field 1 Field 2 Field 3 Field 4
1 1,2,6.8
2 2,3
3 3

Result
Field 1 Field 2 Field 3 Field 4
1 1,2,6.8
2 1,2,6.8
2 2,3
3 2,3
3 3

Any input appreciated, thx
Henrik

 

[Matt Allington]

add a new column using an if statement that returns true or false based on your rules. Then add another step to remove the rows you don’t want.