Transpose column into row csv file
I have a pipeline that reads two csv files from different servers, i want to put together the data of both csv files into one. I used a union snap to put the data together but if one server is down it’s only going to bring me the data of only one server. I put a flag in each section of the file reader, if that flag its true after the join it will check that both flags are true, if yes then write one csv file if not don’t write. But after I configure my join snap i notice that the final csv has more columns, new column names with the prefix “input1_ColumnName”. How can I make that data move from the right to the bottom of the csv file?
Here is a sample pipeline using Gate and Router to verify the existence of data from both input streams. Note that I’m not doing the email off the read fail, but it will still work the same way.
Example_Missing_Input_2020_07_09.slp (17.4 KB)
Input file used: directory.txt (2.1 KB)