topic Re: Merging Known User Data with Looked Up User Data (tFileInputExcel and tLDAP) in Talend Studio

Merging Known User Data with Looked Up User Data (tFileInputExcel and tLDAP)

ml1662663516 — Fri, 15 Nov 2024 21:39:22 GMT

I have an Excel file of user data (name, email, phone, address, etc).

I need to iterate through the Excel file and lookup the user's network id using their unique email address and tLDAP. And, then combine both sets of data into one tFileOutputDelimited.

I have successfully accomplished these two tasks separately.

1 - I can use tMap to get the Excel file mapped over to

tFileOutputDelimited.

2 - I can also use tLDAP to get the user's network id based on their email address.

Where I am getting stuck/lost, is how can I now merge the results of the tMap and the results of the tLDAP into one tFileOutputDelimited?

I don't think I should "trust" that both iterations will always be in the same order. I assume there is some way to "lookup" that the unique email from the Excel file is associated with the unique email that was used to get the user's network id.

I hope this makes sense?

Any suggestions are greatly appreciated!

Re: Merging Known User Data with Looked Up User Data (tFileInputExcel and tLDAP)

anselmopeixoto — Wed, 21 Jun 2023 19:24:54 GMT

Hi @Mark Lammert

From what I've got, you could do it by connecting tFileInputExcel and tLDAPInput to a tMap component and then configure the join inside tMap configuration window by dropping the email column from excel input onto the corresponding column of ldap lookup input.

Re: Merging Known User Data with Looked Up User Data (tFileInputExcel and tLDAP)

ml1662663516 — Thu, 22 Jun 2023 20:46:33 GMT

Thank you.

This is what I ended up doing:

tFileInputExcel -> tHashOutput1

tLDAPInput -> tHashOutput2

tHashOutput1 and tHashOutput2 "joined" to a tMap -> tFileOutputDelimited

Re: Merging Known User Data with Looked Up User Data (tFileInputExcel and tLDAP)

anselmopeixoto — Thu, 22 Jun 2023 20:59:20 GMT

Nicely done. I'm glad it worked.