topic Re: Dynamically changing a value using maps in Talend Studio

Dynamically changing a value using maps

JayZ1 — Sat, 03 Aug 2024 16:26:38 GMT

I am currently getting data from a database, specifically 2 columns that are important.

Database1:

userID

Database2 (Source of validating database 1 information)

userID

In database1 the ideally I would take the userID and use a tMap and find the corresponding userID and Email from Database 2 and pass the email forward for my talend script to use. However database1 has some bad data so I want my use case to be like:

First I check the userID from database 1 and see if it exists in database 2, if it does proceed as mentioned above and pass the Email through. In the case the userID does not exist in database 2 I want to pass the Email from Database1 and see if it exists in Database 2, if it does pass it through, if it doesn't I will just pass nothing.

I know the latter is possible but not sure about dynamically checking and doing both of these cases where its required

Re: Dynamically changing a value using maps

Shicong_Hong — Tue, 06 Aug 2024 02:11:02 GMT

@JayZ1 Take a look at this KB article to learn how to do an inner join on tMap and get the matched/unmatched rows. In your case, you need to do inner joins two times, let me know if you have any questions.

Re: Dynamically changing a value using maps

JayZ1 — Mon, 05 Aug 2024 23:08:08 GMT

I think you may have forgotten to include an article

Re: Dynamically changing a value using maps

Shicong_Hong — Tue, 06 Aug 2024 02:12:39 GMT

Sorry, i have included the article URL.