As your small sample, you have some rows with any and others strange situations my friend… A question: Are all csv files that have been input correctly? headers, columns, rows? Are they at the same format?
The “join node” have a first condition that is: the same “ID” column to match values… if start with some mistakes, all the process will fail. If possible, check the files consistence first…
After the join, check the output of this node before any other action.
If you have the same kind of files, you can use just one node of “File reader” and just configure the option “Files in folder”, set up the file name example and extensions as print below. Just click at “Files in folder”, “Filter options” and then, the options of the files.
Be careful with de delimiters and quotes, they can make a mistake for the information.
Which delimiter do you use in your files? “,” “;” …? Sometimes i set to use pipe “|” because no one use it normally… below this windows you’ll see a example of the data from the files.
After that, try to look what happens at the Join node output. In the Include
At the output, if just set match option, just the top arrow will be actived.
Check the result for erros… if exists, something with the files or the join column exists…you can don’t merge de columns … you’ll have a couple of columns, but you can see and compare both together.
If all is correctly, then try the splitt node.It has a lot of options to join or not the information…
Here you can output as a list (array), as set but will remove duplicated or create a new one. Try it and tell us the result ok?
Tks