Good morning alteryx community;
I have been trying to solve and issue for the last two weeks and I am stuck. Hoping that someone would be able to shed some light on my issues.
I have 2 data sets.
The first data set is my company's expense report data. it includes meals, hotel, etc.
Now i am being asked to bring in the full time employee data. When I create the two flows separately my numbers match perfectly, but when i try to combine them into one single output my numbers dont match.
Basically what i would like to do is bring in my entire FTE data which is based on cost center at the lowest level, and i do not want it to repeat if that cost centre booked more than one expense.
I am also trying to add the cost centre hiearchy so that i can do expense and FTE reporting at different levels of the organization
Attached is a picture of my current flow.
Thank you again for the help it is much appreciated.
