topic Re: Dynamic_join in Talend Studio

Dynamic_join

karthik_T — Thu, 31 Jan 2019 11:35:08 GMT

Hi,

i want to do the joining of two files dynamically based on the user input.example if user enter id it will join with id . how to do it in talend.

Thanks.

Re: Dynamic_join

David_Beaty — Thu, 31 Jan 2019 11:41:38 GMT

Hi,

I don't think you can change the columns you join on dynamically, but what you can do is change the data in a given column dynamically.

Example, in the 2 sources that require joining, add an extra column to both called JoinColumn, when the data is read in, populate this column from each source based on the user input, then just join on JoinColumn. This will probably have to be set as a String, formatting any non-string column values to string as need be.

Re: Dynamic_join

akumar2301 — Thu, 31 Jan 2019 12:36:22 GMT

Can you please explain your senario with example and data.

Re: Dynamic_join

karthik_T — Thu, 31 Jan 2019 13:05:19 GMT

Hi akumar,

I have two files file1,file2 & i want to join those files dynamically based on user input.

for example user enter "ID" then ID column from first file should be join with matched column data of second file dynamically.

If user enter "Name" then name column from first file should be join with matched column data of second file dynamically.