Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
chou
Contributor III
Contributor III

Treat file line by line

Hello,

I want to so this type of action, I have in input a file :

A1;A2;A3;A4

B1;B2;B3;B4

C1;C2;C3;C4

D1;D2;D3;D4

I want to generate 4 outputs :

A1

A2

A3

A4

The same

B1

B2

B3

B4

To converte from columns into rows I used the component tNormalize, but to treat data line by line, how is it possible? I used tFlowToIterate, but it didn't work.

Can you please help me?

Labels (4)
1 Solution

Accepted Solutions
chou
Contributor III
Contributor III
Author

Hello, thank you every one,

It worked by usding tFlowToIterate, than tNormalize.

I can mark this issue as resovled

View solution in original post

3 Replies
jzhao
Employee
Employee

Hello,

Did you check the scenario: https://help.talend.com/r/en-US/8.0/processing/tnormalize-tfileinputdelimited-tlogrow-tlogrow-configuring-components-standard-component

Anonymous
Not applicable

Hi

Read the file line by line using tFileInputFullRow, and then iterate each line, finally, convert from columns to rows using tNormalize component.

 

Regards

Shong

chou
Contributor III
Contributor III
Author

Hello, thank you every one,

It worked by usding tFlowToIterate, than tNormalize.

I can mark this issue as resovled