How to merge CSV files

I have ‘n’ CSV files which have different data only in the first column separated by “|” but don’t have a header in a folder. How can I merge all of them into one single CSV file?

You can use the UNION snap.