Data Combination -

Question

I have a workflow where I want to combine two Trial balances and group them by GL account and Account Type.  There are a number of TB in the data output -- but I want to group them as follow :

Fund 28 and 29

Fund 30 and 31

Fund 32 and 33

I'm able to consolidate only the top one -- but having issues with the other grouping ..  Also , if possible can I create for each combination 3 tabs -- Consolidated TB /  Fund X / Fund Y.   for each of the fund group

TB Combination.yxmd

mot · Accepted Answer

Hi @ll98 ,

Please see the attached workflow for your first issue. I hope this helps.

Also, could you explain the 3 tab issue more, maybe with an example? Best.

Qiu · Accepted Answer

@ll98 
This should be a simple fix.

In the filter, it should be "or" not "and"

mot · Accepted Answer

Hi @ll98 ,

For the second question, does this workflow resolve your issue? Best.

mot · Accepted Answer

Hi @ll98 ,

See attached workflow.

I hope this helps. Best.

mot · Accepted Answer

Hi @ll98 ,

This might be one way to do it. Check the second one. Best.

ll98 · Accepted Answer

Thanks @mot