Hi Community,
I am new to alteryx and trying to find a solution for my problem.
I have a text file with data as shown in the attached file sample_input_file.
I need to read the part of header value and need to append to the below rows till a new header is available.
Thanks in Advance
Motadikela
Solved! Go to Solution.
Hey @motadikela!
I would try adding a Multi-Row Formula tool to create a new field that just contains that section's header like so:
Then, add a normal Formula tool to concatenate the headers with the following expression for col1:
iif(Contains([col1],"["),[col1],[NewField]+[col1])
You could then use a Select tool to get rid of that new field you created, but the output I got looks like this:
Hope this helps!
Thanks Barnes, Its working as expected.