how to apply different values in join as a filter

[sekertu]

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

[manodwhb]

@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

[sekertu]

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.