Hello,
I have an input tool with a table containing a single column with string data. The first row of the table contains different strings, seperated by '|' delimiter. The other rows contains truncated characters which are seperated by space. I am trying to use Text To Columns tool to seperate the truncated characters into distinct fields according to the number of strings in the first row but I find it a little bit challenging.
Any help would be greatly appreciated
Thanks in advance
Hi @Inactive User
Can you provide some sample input and expected output It will help us get a better understanding of the usecase.
We will be happy to help : )
Yes, of course @atcodedog05. Actually it is one of the Challenges from Alteryx Community. I attached the input data and the expected output data as .yxdb files. Thank you