Example below So basically there will be 5 files similar to the below example but with a lot more rows. So The columns will be all the same at least for every single file, So I would need to first remove the first three rows from each file(though i can do that manually if needed.
Then Select so only certain columns are used. Basically just identifying information such as name, email, event title, line of service.
Then basically merge all 5 files, so they are all one file. Basically just shoving the information from each file under the next, there is no real need for matching or unions or anything. Just Everything from the chosen columns gets added. So using the below as an example, if each file only had 3 entries then first file would be rows 2-4, second file rows 5-7, third file 7-9 and so on.
I am probably overthinking the difficulty but I tried doing something similar once and alteryx kept skipping files because one file had 20 rows another had 15 and it caused a bunch of weird issues.
This will ultimately be used in a Tableau so the person I am working with can see how long people from various departments and business ranks watched various training videos.
The only other step I need to figure out is how do I get all the data from a 6th excel file that is just emails and ranks(these reports below do not have the rank part so I needed to collect that separately)
Example
| Audience Details Report | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| Report Run on: 11/09/2020 02:44:16 PM EST | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| Event Id | Event Title | Cost Center | Registered On | First Name | Last Name | Title | Email | Company | Address 1 | Address 2 | Country | City | State | Postal Code | Phone Number | Mobile Number | Fax Number | EmployeeID | LineofService | workerid | IP Address | Live Sessions | On-Demand Sessions | SimLive Sessions | Total Sessions | Live Duration | On-Demand Duration | SimLive Duration | Total Duration | Survey exit 1 | Survey exit 2 | Survey exit 3 | Survey exit 4 |
| 8675309 | Event | USA | ######### | Bob | Newhart | | Test@test.com | | | | US | Spartanburg | US-SC | | | | | 90210 | Division X | 888888 | | 0 | 0 | 0 | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | | | | |
| 8675309 | Event | USA | ######### | Groucho | Marx | | Test@test.com | | | | US | Boston | US-MA | | | | | 90210 | Division X | 888888 | | 0 | 3 | 0 | 3 | 00:00:00 | 00:12:40 | 00:00:00 | 00:12:40 | | | | |
| 8675309 | Event | USA | ######### | Harpo | Marx | | Test@test.com | | | | US | Melville | US-NY | | | | | 90210 | Division X | 888888 | | 0 | 1 | 0 | 1 | 00:00:00 | 00:24:00 | 00:00:00 | 00:24:00 | | | | |
