Help in Importing a batch txt file which inconsistent file format

[sumaiyakhatun786]

Hello Team,

I want to import set of file from a folder, where every week new file is added . the format of the file is as attached . 

.tx batch file has junk or log info above, then multiple data blocks that all start with
|SGrp||Submission| (i.e., the header line). When I am trying to import the file and its coming in one column , but the header are splitting into two columns .  here row 13 and 14 both are headers.  Also the following rows the data inputs are spliting into two as well.

I want to import those set of files where data points are aligned under each header and no logs or specials char. I have just stared using alteryx so have not faced this kind of file before, any help will be apppreciated.

[davidskaife]

Hi @sumaiyakhatun786 

What error are you getting with the second Macro, assume you have updated the input?

Regarding the second issue - you'll need to update the IF statement to accommodate this, so something like the below, please adjust accordingly

IF StartsWith([Field_1], '|Customer')
THEN 2
ELSEIF StartsWith([Field_1], '|')
THEN 1
ELSE 2
ENDIF

 the