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.
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.
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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Accelerate your data lake projects with an agile approach