This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I need to add a footer but this has different number of columns. Mine is a CSV file. So, when I add the footer, first, it add double-quotes surroinding part of my footer. Then, it adds as many commas to complete the same number of the file.
Is there a way to add a row with arbitrary content and without the double-quotes?
@KaneG Thanks for your reply. The main stream of data is a CSV file. Then I'm using Text Input, Select, and Sample tools to Union this with the main stream. I tried your suggestion but it didn't work. Could you please take a look on my existing workflow.
I did mine a little differently, as I had a footer with 2 data points: the date and the record count.
So basically I created those fields with a formula then unioned them to the bottom of the actual data.
Then because I was stacking a date into a column that was really an 3 digit ID string field, I was able to create a formula that said if the length of the string is less than 4 characters then combine all the columns with pipe delimiters between them. There are about 10 columns of data. If the length of string was greater than or equal to 4 then only concatenate the first 2 columns (which would be the date and record count), which eliminates this issue:
Then for the headers I just have a text file with the column headers all laid out with the delimiter in there, so it gets unioned on after that and I have it all in the first column.
So then I deselect all the data except the one newly constructed column of concatenated data. Output as CSV and you have a perfectly delimited csv file.