topic Re: how to apply different values in join as a filter in Talend Studio

how to apply different values in join as a filter

sekertu — Sat, 16 Nov 2024 01:18:50 GMT

Hello all,

I am new at Talend, I am trying to develop a job which will have a join in Tmap. While joining two tables a variable is used in the code.

let me explain a bit clearly. You can see my job below.

In the code (after on statement) there is this statement: AND ud.i_usagetypes = %USAGE_TYPE%)

this usage_type has 1,2,3,4,5 values. there is an iteration in the code.

I am not able to find a way in order to apply it to my work.

there should be an iteration but I don't find the solution.

I'd be glad if you help me.

Thanks

sekertu

Re: how to apply different values in join as a filter

manodwhb — Tue, 13 Oct 2020 03:56:24 GMT

@TUGBA SEKER CAN , use the tfixedflow to have the required values and iterate using tflowtoiterate and then connect your rest of the flow and so it will iterate value by value.

check the below link to about tFlowtoiterate component.

https://help.talend.com/reader/vn0o8XYVXXNgJkRtWjet9A/FFa3Y3_DRo0KOopVtTzPMA

Thanks,

Manohar

Re: how to apply different values in join as a filter

sekertu — Thu, 15 Oct 2020 08:12:48 GMT

Hi @Manohar B ,

I tried your solution it seems it is working.Thank you. But I am not sure whether it affects the second part of the union or not. I wrote the '" + ((Short)globalMap.get("row1.i_usagetypes")) + "' filter to both side of union. seems iteration finishes before second part starts.