Hi all,
I'm a bit new to Alteryx, so my understanding of the tools available through the program is a bit lacking. I have a master excel document with monthly employee headcount data, as well as accompanying information. A basic example for one month of data would look a bit like this:
Employee Name | Employee ID | Department | Supervisor | Class | Continued Employment? |
John Smith | jsmith1 | PD | Supervisor 1 | Base | 1 |
Jane Doe | jdoe3 | DB | Supervisor 1 | Non-base | 1 |
Bob Robert | brober5 | PD | Supervisor 2 | Base | 0 |
The excel file contains something resembling this table over the course of a full year, repeating each of these columns for every new month. I am attempting to use Alteryx to clean this data up a bit to later be used with Qlikview. Currently, I am having trouble with understanding how to differentiate the data through Alteryx in order to keep each month separate from one anther, but still related in some sense.
I apologize if this question is a bit dumb, or unclear. Alteryx is very new to mean, and I just have the basics down. I'd be happy to clarify any questions, and any help would be greatly appreciated.
Solved! Go to Solution.
This is a great use-case for Alteryx. Is your monthly data in different worksheets within the Excel workbook? Or are the monthly tables all on the same worksheet? Or is it one big table with all months having the same columns?
This will determine the best path to solving.
Hi @Tmagdich
A expanded sample would help a lot in this case. Specifically, a couple of months of data along with the field that help differentiate between months. Is there a month column? Does the monthly data come from a separate file per month?
Dan
It's all within one one sheet. All columns are repeated for each month, as some fields can change over time (supervisors, departments, employment status, etc). I've attached a clearer example that better shows the data how I am viewing it. It shows 3 of 12 months, and all personal information was of course removed, but it should give you a much better idea of my starting point.
I've attached a sample that better shows what I'm working with. It shows 3 of the total 12 months worth of columns, and all personal data was of course removed. Other than that it should give you a clearer view of my starting point.