Check the result set of the tmap expression on other column before inserting it

[Anonymous]

My question is that, how can I check if the result set of that expression above is exists on other column on the same table? And if exists I will keep it on the right destination column, but if not I will insert it on other column instead?

my component set-up is:

tfilelist -> tfileinputdelimited -> tmap -> tmysqloutput(1&2)   

1&2 that meanss that I'm populating the data from source to 2 destination table, one is for delta and one is for full. Only on initial or first run, then after this I have another the same component set-up, but only tmysqloutput2 in the output as that is for delta. Hoing someone can help me out on this?

[manodwhb]

@Moe,i will suggest you read the source data and load to memory by using tHashoutput and you can read the dame data multiple time do the comparison by using tHashInput.

[Anonymous]

@manodwhb I will try to consider your suggestion and if woks, then I'll accept the answer/solution.

[Anonymous]

I'm thinking if this will work on my set-up as I need to update:

https://community.talend.com/t5/Design-and-Development/resolved-Update-field-values-based-on-Update-...

[manodwhb]

@Moe,check ,if it be help in your case.

[Anonymous · Accepted solution]

This is already fixed by using lookup and left join then compare the integer before UPDATING values.