Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
carosim
Contributor
Contributor

Split file into several flow

Hello,

I have a long file with several blocks and différent line number. I would like to iterate over each block but I can't.

Do you have any advice? Thank you for advance.

Test 1 "toto"

data

x y color

1 2 blue

5 6 green

3 2 pink

Test 2 "tata"

data

x y color

2 7 red

Test 3 "titi"

data

x y color

2 9 yellow

2 1 blue

Labels (2)
2 Replies
sagu
Contributor
Contributor

can you please let us know, what output you are expecting ?

carosim
Contributor
Contributor
Author

0693p00000C8WprAAF.pngI read the file in raw in a block for the first time, I divided the file with tjavarow to count the line numbers of each block.Then I reused the row number information obtained with a tflowtoiterate to read each block with tfileinputdelimited.

Hope it can help other people if it's the right way.