@JosAngelHG: Welcome to the community!
Before putting your Join [merge] snap, try to go ahead with File Reader and validate if the files are getting loaded. The output preview (marked green) on your first file reader should be seen for all 3 file readers.
As pointed out by @marjan.karafiloski, please do check whether the files are existing on a shared project space for which you have access rights. If youāre reading a file from your local, please do ensure that the file name is not changed and kept in the same location. Once you select the desired file in the file reader, usually a copy of it is saved in the same project space where youāre building this pipeline however to be on safer side as you might change the execution type to āValidate and Executeā, not modifying the file location and file name on your local would help.
- Please get those output previews on each file reader
- Rename 3 file readers to a meaningful name
- Put a csv parser as you have kept it now
- Use a mapper after each csv parser
- Select the columns desired in the mapper
- Use Join [merge] to merge the columns
P.S.: Please ensure that the column names are a bit different if youāre expecting same fields so that it will help you determine which fields youāre going with. Also, check the output preview and wait for that green symbol before putting further snaps.
Best Regards,
Darsh