cancel
Showing results for 
Search instead for 
Did you mean: 

Fill column data based on header values throughout file

traci_heiser
New Contributor

Hello!

I have a fixed width file I am parsing in snaplogic, and there are multiple header records throughout the file. I need to create a column by stripping out part of the header record and filling the column data with that value for each row of data underneath it, until I get to the next header record, strip out the same section of header record to fill data underneath that, and so on. For example, the first header record contains '0001', and I need to create a column called 'CODE' that contains this '0001' value. The second record contains '0002', and so the next set of data records need to contain '0002' in the 'CODE' field. I have a conditional snap that strips out the '0001' and creates the 'CODE' column in the header record, but how can I fill the data underneath that record with that value?

1 REPLY 1

traci_heiser
New Contributor