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 |
