topic Re: IF ELSE Statement in tMap in Talend Studio

IF ELSE Statement in tMap

Anonymous — Wed, 21 Mar 2018 15:35:03 GMT

Hi everyone,

The field "revision" in the Output of the tMap component should be a counter, which depends on the three fields "T_SNR_SP", "T_SNR_SD" and "T_SNR_STAMM" from the Input. If there is a change in these three fields, the counter should begin at 1 again. It's like a groupchange.

In Java I would do it with a cache variable like these:

String T_SNR_SP_old = "";

String T_SNR_SD_old = "";

String T_SNR_STAMM_old ="";

for (int i = 1; T_SNR_SP_old==T_SNR_SP && T_SNR_SD_old==T_SNR_SD && T_SNR_STAMM_old==T_SNR_STAMM; i ++){

revision = i;

}

revision = 0;

T_SNR_SP_old = T_SNR_SP;

T_SNR_SD_old = T_SNR_SD;

T_SNR_STAMM_old = T_SNR_STAMM;

How can I do this in the tMap componente? I know, I could do this in the tJavaRow componente, but then I can't use the tMap component anymore.

Thanks Katharina

Re: IF ELSE Statement in tMap

Anonymous — Wed, 21 Mar 2018 15:45:31 GMT

Have a read of this tutorial and try to understand what is happening with the tMap variables. If you grasp this, you will easily be able to resolve your problem.....

https://www.rilhia.com/quicktips/quick-tip-compare-row-value-against-value-previous-row

Re: IF ELSE Statement in tMap

vboppudi — Wed, 21 Mar 2018 16:03:20 GMT

Hi Katharina,

Are you looking for the following group id creation. Basically based on three attributes Col1,Col2 and Col3 group id will be created. If Any change in these three columns then group id will start from begin.

Regards,

Re: IF ELSE Statement in tMap

Anonymous — Thu, 22 Mar 2018 08:02:53 GMT

Thanks, that solved my problem