Hello all,
I have a blank csv file (template) with headers that I want to fill according to different csv files.
After importing the blank csv file I have a table like this,
ID | Country | Weight | Height | Age | Language | Passport |
One if the input files I have looks like this,
ID | Age | Passport |
1 | 31 | y |
2 | 32 | y |
3 | 33 | n |
4 | 34 | y |
I am wondering if you could give me a hand with the workflow that would generate the following output,
ID | Country | Weight | Height | Age | Language | Passport |
1 | 31 | y | ||||
2 | 32 | y | ||||
3 | 33 | n | ||||
4 | 34 | y |
I need to keep all columns, even if all entries are blank.
I have been using the Join block to achieve the goal but it is not working - I am definitely doing something wrong.
Any suggestions will be quite appreciated.
Solved! Go to Solution.
Have you tried using the Union tool instead of the join? Use your blank csv file with the headers as the first connection coming into the Union
yeah, that is what I was looking for. I was not aware of such block.
Cheers!