Auto adjust dates/columns in PQ

[bigdataguy]

Hello all, I've set up a forecast file in PQ that automatically updates customers, invoices, balances, etc. [all data from the balance column to the left is in PQ]. In the output table, I have dates set up that I manually update [this date range is not in either the extract file or the transform area].

Is there a way to set up the date columns in the transform editor, that will automatically adjust based on the month/dates [column headers, # of days in the month]? I know I can add 31 columns [for Dec], but I have to manually change the headers and account for 30 days vs 31 days, at this point with my limited knowledge. Thanks!

 

[Automatrix]

You can arrange the daily data in a single column.

Book1
	A	B
1	Date	Value
2	01/Dec	2
3	02/Dec	4
4	03/Dec	3
5	04/Dec	5
Sheet3

Then do whatever filtering you need in PQ, finally Pivot Table by the Date column (Values Column: Value).

Result:

Book1
	A	B	C	D
1	Date	Value
2	01/Dec	2
3	02/Dec	4
4	03/Dec	3
5	04/Dec	5
6
7	01/12/2022	02/12/2022	03/12/2022	04/12/2022
8	2	4	3	5
Sheet3

 

[bigdataguy]

The output table I'm using is an actual data table, not a pivot. I'm trying to figure out how to, if possible, do everything within the query editor

 

[Automatrix]

The output table I'm using is an actual data table, not a pivot. I'm trying to figure out how to, if possible, do everything within the query editor

It probably is, but I'm not sure what you are trying to do. Can you show your input and desired output?