Hi Alteryx Team
This is my workflow. I need to push table2 into the main table based on the Date and the state. The 2 columns(In(Count) and Out(Count)) are also created to the main file. and they are then summed up.
How to I fit in data from my main table -
Date | In | In (Count) | Out | Out (Count) |
9/2/2019 | 30 | 15 | ||
9/3/2019 | 20 | 13 | ||
9/24/2019 | 10 | 12 | ||
9/30/2019 | 5 | 9 |
This is my other table2-
(this could be a State of In too - but right now the summarised output is as such - but it should factor the case ie if there is an In state)
Date | State | Count |
9/24/2019 | Out | 1 |
The output should be as such -
Date | In | In (Count) | Out | Out (Count) |
9/2/2019 | 30 | 1 | 15 | |
9/3/2019 | 20 | 13 | ||
9/24/2019 | 10 | 12 | 1 | |
9/30/2019 | 5 | 9 | ||
Total | 65 | 1 | 49 | 1 |
Solved! Go to Solution.
@henrygeorge what have you tried so far? Can you post your workflow with sample data?
Hello @henrygeorge ,
I think this could do it. This workflow takes into account the state and separates it into the two columns:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards
@afv2688 I have edited the data. The only problem I'll be facing with your workflow is that - My table2 is right now looks like this with a cross tab tool -
Date | Out |
9/26/2019 | 1 |
When joining this you created an empty col 'In'. I don't have an this right now...So how will it work in Join ie renaming a non existing col. But if it was there was I need to follow your logic (there is a chance it could be there as the above is summarised result)
Also I put empty columns in the main file In (count) and Out (count).
Please do Help me solve this
@afv2688 Would I need to use some kind of filtering?
Hello @henrygeorge ,
You could add manually the column names like this:
Is this what you are looking for? Regards
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards