topic Re: Read full file for processing all rows at once in Talend Studio

Read full file for processing all rows at once

Anonymous — Fri, 07 Jun 2019 07:32:51 GMT

Hi,

I've the below data:

Filter,Flag
A,N
B,N
C,Y
D,Y
E,N
F,N

I've to create a condition to check both C and D at the same time. Since my job is reading row by row, the condition for both C and D as Y is always false.

Please advise.

Thanks.

Re: Read full file for processing all rows at once

TRF — Fri, 07 Jun 2019 08:26:39 GMT

If your file is as small as shown on your example, you connect your tFileInputDelimited to a tSetGlobalVar ot tFlowToIterate component giving one global var per record where the name is based on the Filter filed value and the value is based on Flag field.

On subjob, you can compare the records value as desired using corresponding global var.