Read data from a txt file and need to process data based on header records

[motadikela]

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

[Kenda · Accepted 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!

[motadikela]

Thanks Barnes, Its working as expected.