Dinamically organize columns

I need help on how to dynamically organize columns related to Date, but there always must be an extra column at the end for "YTD Total"

This workflow is design to reed all Trial Balances from a folder (qty of files in this folder increases every month) and generate a report with multiple sheets, some by Cost Center showing values by expenditure category by month plus the YTD Total.

The expected result would be like in image "Order ok"

The expected result for next month would be like in image "Order next month ok"

Instead every following month I run this workflow I get following result (Order next month NOT ok)

Any idea how I can get those columns dynamically organized?

Thanks!

Order ok.jpg

Order next month ok.jpg

Order next month NOT ok.jpg

WORKFLOW.yxzp

Output.xlsx

Output

Dynamic Processing

Accepted answers

Seba

I found a solution using a macro that generates the month columns I need for each report, and then I use the Union tool to join the transactions with the calendar table.

All comments

binu_acs

@Seba The workflow is not uploaded properly, the calendar macro and the input file, can you upload a simple input file and expected output for better understanding,

AncientPandaman

one of the simple ways is to move the "Dynamic or Unknown fields" above the "YTD total".

just apply to the last select tool/table tool

Screenshot 2025-01-21 092147.png

Seba

I found a solution using a macro that generates the month columns I need for each report, and then I use the Union tool to join the transactions with the calendar table.

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335