Dynamic_join

Highlighted
Five Stars

Dynamic_join

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.

 

 

Nine Stars

Re: Dynamic_join

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.

 

Regards David
Dont forget to give Kudos when an answer is helpful or the solution.
Nine Stars

Re: Dynamic_join

Can you please explain your senario with example and data.
Regards
Abhishek KUMAR
( Please mark the post as resolved if you found your solution )
Five Stars

Re: Dynamic_join

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.

 

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.