how to load header, detail and footer record into ... - Qlik Community

Mkrishna · ‎2017-04-13

Hi

I have a file(txt) with header,detail &footer records , now i want to load all the records into a single file with some sequence no for header and detail & footer.

how can i achieve this .............. please help me anyone.

Anonymous · ‎2017-04-13

Hi mahadevan,

If we understand your requirement very well, you can generate a sequence with a tMap component.

Please create a variable in the tMap with the following expression

Numeric.sequence("s1",1,1) and link this variable to a new out column. Feel free to let us know if this solution is Ok with you.

Best regards

Sabrina

Mkrishna · ‎2017-04-13

hi, iam having a data in a file with multi schema like header and detail&footer now

1.how can i load this data into a single file

see my input (Positional file)

HA00000000051070UPAULINA Wdavid john

DA00000000051070S000009003RESSupply 01012015Summer Charge 240 kwh 200

DA00000000051070S000009003RESSupply 01012015Summer Charge 240 kwh 220

FA00000000051070S000009003M000004576ELECT1 010120150131201531

HA00000000155650UPAULINA Wraj warner

DA00000000155650S000009003RESSupply 01012015Summer Charge 140 kwh 110

DA00000000155650000009003RESSupply 01012015Summer Charge 340 kwh 300

FA00000000155650S000009003M000004576ELECT1 010120150131201531

like data is for more than one customer with multiple header,detail&footer

Mkrishna · ‎2017-04-13