topic Re: [resolved] Can we write query in tmap? in Talend Studio

[resolved] Can we write query in tmap?

Anonymous — Sat, 16 Nov 2024 12:49:08 GMT

Hi,
Can we write query in tmap?
Actually my problem is something like this,
During transformation in tMap component, I want to check whether data already exists or not? If it exist than I would like to change it with some additional information.
For example,
if XYZ-WERB is already exist in SKU column than I would like to add some number at the end of SKU so I can eliminate duplication from SKU column.
For more information consider attached snapshot of my tmap component. So can we write query in "Expression" to check whether data is already exists or not in column?
Thanks.

Re: [resolved] Can we write query in tmap?

Anonymous — Mon, 11 Jul 2011 12:35:28 GMT

Hi
No, you can't execute a query on tMap, you need to use A db input component to select all existing records, and do a inner join with source records, get the matched records, that are already existing records in database.
Best regards
Shong

Re: [resolved] Can we write query in tmap?

Anonymous — Mon, 11 Jul 2011 14:36:20 GMT

Hi,
Thanks for reply shong. I got what you want to say. DB input is the last and most reliable way. But is there any other way to check whether data already exists while transforming data through tmap? so I don't have to recalculate my all data.
Thanks.

Re: [resolved] Can we write query in tmap?

Anonymous — Mon, 11 Jul 2011 17:39:08 GMT

Check other answers in the forum, that suggest the use of hashmaps...