Dynamic_join

[karthik_T]

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.

[David_Beaty]

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.

[akumar2301]

Can you please explain your senario with example and data.

[karthik_T]

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.