Forum Discussion
Trial balance trasformation
Hi Anonymous ,
Here's my solution.
1.Duplicate a table out, then keep half of the two tables, and unify the column names.
2.Append.
3.Group by.
4.Add custom columns.
5.Expand columns and remove the unneeded columns, then filter rows. Keep the row whose index is 1.
6.Add a custom column to get file name.
Here's the results.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Here's my solution.
1.Duplicate a table out, then keep half of the two tables, and unify the column names.
2.Append.
3.Group by.
4.Add custom columns.
5.Expand columns and remove the unneeded columns, then filter rows. Keep the row whose index is 1.
6.Add a custom column to get file name.
Here's the results.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous,
thanks for your answer.
However I dont know who accepted it as solution but it is not solving the problem.
You are still bringing subtotals for some accounts (which is wrong). Moreover you are achieving the result using 2 queries (for the first step, e.g. split credit/debit) and it would be much better having just 1 query
Can you please achieve the result with 1 query and cleaning subtotals as well?