Input Header Starts on Different Lines
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a single report that Alteryx reads from.
It's downloaded daily and just gets overwriten in the folder that Altrerx reads.
Sometimes it comes in with the header starting on row 10.
Other times it comes in with the header starting on row 11.
How can I use a single input that will test where the header?
I can use an input tool se to read data starting at line 10 but when happens when the report generated starts at line 11 and pushes the header down a row?
Can't seem to find the solution in community.
Thanks in advance.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Also, I should point out that this file is a csv.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If your header line is consistent, you should be able to use a keyword to help identify which line contains the headers after importing everything on the sheet. Once you identify that, you can create a flag to filter for the header and the subsequent data, and then use a dynamic rename to bump the headers up.
In the example attached, I have two sheets. The data is the same on both, but they start on different lines. I have two streams in the workflow to example, but the one will work for either sheet.
I imported everything in the sheet by selecting that the first row contains data so it doesn't pick up any headers. From there, I used a multi-row formula to identify the line that has Customer_ID in the row (header) and anything after it. I used a filter to isolate the headers and a dynamic rename to move the headers to their proper place.
Hope this helps!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
echuong1 This is exactly what I'm looking for.
Thank you!! 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks a lot for the solution! This is incredibly helpful.
Now the challenge is how do I use this with dynamic input. E.g Single excel workbook with multiple sheets all with different header rows.