How to configure the "summary tool" for new columns or when they change their name?

[AMERINO]

Hi community!

I need help to do a "Summarize" of some columns whose name changes.
 
I explain my need:
Monthly I make a sales report. This report presents the data by month and accumulated data of the year.

But every month a new column appears in the source file (new ended month) and I don't know how to include this column in the Summarize tool

So, for exemple in March:

Customer Id	Client	Seller	2018.01	2018.02	2018.03	Accumulated
001	Client 1	Seller A	100	120	130	350
002	Client 2	Seller B	50	50	100	200
003	Client 3	Seller A	20	50	30	100

and Summiarize tool configuratión:

Field	Action	Output Field Name
Seller	Group	Seller
2018.01	Sum	Sum_2018.1
2018.02	Sum	Sum_2018.2
2018.03	Sum	Sum_2018.3
Accumulated	Sum	Sum_Accumulated

but April input file:

Customer Id	Client	Seller	2018.01	2018.02	2018.03	2018.04	Accumulated
001	Client 1	Seller A	100	120	130	150	500
002	Client 2	Seller B	50	50	100	100	300
003	Client 3	Seller A	20	50	30	50	150

and my flow doesn't have that new column entered (2018.04) in the Summiarize tool configuratión. This means that every month I have to edit the summarize tool configuration.

Any ideas? 

Thanks in advance!

[Thableaus · Accepted solution]

Hi @AMERINO 

Use Transpose tool and Cross Tab tool and check the "Dynamic and Unknown Fields" 

You'll summarize the field "Name", that will contain all of your columns, even though they are dynamic.

Workflow appended.

Cheers,

[Thableaus]

@AMERINO 

If you happen to add new dynamic columns that are not related with months, you can filter them out based on some kind of rule you may find appropriate before "crosstabbing" them.

Cheers,