Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Previous/Next

Hello,

We have a flat file like that

1010101CODE1

1010201tttttt

1010301xxx1

1010301xxx2

1010101CODE2

columns mapping depends of line type:

'1010101' lines explains all codes (position 8 à 13)

'1010201' line below 10101 lines related to informations (A) about 1010101 code (position 8 à 12)

'1010301' lines (multiples) explain other informations (B) about 1010101 code (position 8 à 12)

I need to put correct codes in each lines but I have some problems with 10103 multiple lines with previous functions

For example:

CODE1,1010101CODE1

CODE1,1010201tttttt

CODE1,1010301xxx1

CODE1,1010301xxx2

CODE2,1010101CODE2

Could you help me please ?

Thanks a lot

Régis

0 Replies