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.
