Hello All,
I have a file where one particular column has so many items say like numbers which are separated by semicolon(;) .In current scenario(excel) what am doing is first am doing a text to column and separating it to multiple columns and with other file am vlookuping all the columns int e file and getting the data , But with Alteryx am not sure how to do it easier as when i tried using text to column i need to specify how many columns i need to split(in this case i dont know how many as it may vary for each row) and even ig i give some random number how can i do a join (which is Vlookup in Alteryx as join just work on one column match).
Can anyone help me on this??
Regards
Rajasekar
