Joining the files in 'Join With' recipes

Ravikumar_Settu

Dear All,

Is there any possibility to join more than 2 files at time? Or the Application behaviour itself, work like joining 1st & 2st file first, post the result; need to join with 3rd file.
Even the venn diagram in the Join option show only 2 circles not 3 circles.

Operating system used: DATAIKU

Turribeach

depending on what you are trying to do the Files in Folder dataset might fit the requirements. However you haven’t specified exactly what you are trying to do can you please clarity? Do you have a bunch of files you want to load? Are the files all of the same format?

Ravikumar_Settu

I have bunch of file to load, first 3 columns in the all 3 files are same - remining columns are different in each files. Now I need to compare based on the first 3 columns with other files. This is the actual requirment now.

Turribeach

Do you need to load all the columns of all the files or just the first 3 columns? If you need to load the full files and the format of the files is different you will need to create a different dataset per file or use a Python recipe to dynamically load the files.