I could be wrong but I'm not sure that's possible. Why is it that the data coming into the Flow does not already have a header?
Thank you for your reply. I kind of figured out it's not possible, at least not with the current functionality.
My options are:
1. run a command prompt line that concatenates the files, with the file header at the top, and then import the consolidated file and indicate the header line as the first line
2. combine all files first in Tableau Prep with the "multiple files" option and a "generic" header (F1,F2,F3...), and then add a step in Tableau Prep where I manually type the header for the combined file.
I've opted for the second solution.
Relative to your question, the system that dumps the file does not generate a file header in the text format; i can do it as an xml, but then reading the xml files might generate some issues.
Yeah I would have gone with option 2 as well. If it's automating adding the headers in Prep then anything to do with the missing headers before this becomes moot.
You may be able to use tableau prep for option one. If all of the columns in all of the data files are the same. Use Tableau Prep to do the concatenation and then output the file to use used a new input.
1 of 1 people found this helpful
Yes, this is possible with a little initial work in Tableau Prep for your first option. It won't be automatically joined unfortunately. Please see below screenshots with some mocked up data. And this help file in Tableau Prep (about middle section): Join or Union Data - Tableau Fixing Mis-Matched Fields. If this resolves your question, please mark this response as correct. Thx! Don
Here's an Excel file w/Header only:
Here's the Excel file w/No Header:
Bring both files into Tableau Prep:
Then perform a UNION, not a JOIN, by dragging one on top of the other:
In the left side pane you'll notice that the fields are mis-matched. Color-coded by Excel sheet inputs:
To globally fix the mis-matched fields, place your cursor on each field to select the two fields that match, then right-click and "MERGE". Do that for each field until done:
When done, you'll have a view that looks like this:
Finally, select an output step:
Thank you for the suggestions! While not a direct route, I was able to make it work!