3 input file combine to 1 file

[lovebau]

I have 3 different input files and I wanted to create one output file from these 3 files. What node can i use? I tried the joiner node but it’s for 2 files only?

[ArjenEX]

Hi @lovebau

Use a concatenate node and add the desired number of input ports by clicking on the plus icon. Connect all your sources accordingly. Example:

Some file readers also support reading all files at once and automatically merges all the inputs but that depends on your use case.

[lovebau]

thank you for this and I already tried it thank you! However, for the 3 input files they have one common column that I wanted to compare. Example, all the input files have asset name and I wanted to compare if the cost are the same for the three input files… what node can i use?

[ArjenEX]

Then use consecutive joiner nodes to link a to b and a to c. Use a Rule Engine or Column Expression node to evaluate the values.

[lovebau]

Is this correct? looks like it’s not working?

[ArjenEX]

No, forget about the concatenate in that case

[lovebau]

waaaah it worked! thank you so much! you are very helpful! I will then use the rule engine node for comparing right?

[ArjenEX]

Yes, rule engine is the easiest to work with.

[lovebau]

currently working on the rule engine