Seperate truncated characters into distinct fields

Question

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

unknown · Answer

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

Input Data.yxdb

Output Data.yxdb

atcodedog05 · Answer

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 : )