Output Issue

[henrygeorge]

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

[patrick_mcauliffe]

@henrygeorge what have you tried so far?  Can you post your workflow with sample data?

[afv2688]

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

[henrygeorge]

@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

[henrygeorge]

@afv2688 Would I need to use some kind of filtering?

[afv2688 · Accepted solution]

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