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?
