Filter coulmn based on quarter

[AliEB]

Hi,

I do have a question based the "Dynamic Select" tool. I have the following column:

and i like to have only the column until todays quarter "Q22022".

Does anyone know how to make this happen?

Thanks,

Ali

[IraWatt]

Hey @AliEB,

 What I think you would want to do is transpose then filter the column names followed by cross tab:

what do you mean by "only the column until todays quarter "Q22022"." do you just mean the latest column?

HTH,

Ira

[DataNath · Accepted solution]

Maybe super long-winded but this seems to get the job done and will be dynamic if you run it in future.

[AliEB]

This actually is near to the solution I need. The problem is that I have to aggregate at the end and if I concatinate it will be listed everything into one row, but I need everything seperated... Do you have a solution for this?

[DataNath]

Surely you could just add a formula tool on that sums all of the columns that are left at the end?

[IraWatt]

@AliEB , Do you have an example workflow of where your up to ?

[AliEB]

I do not need the sum. Right now after aggregation, the value of the column is comma seperated. I don't need that, I want to have every value in one cell. Right now it looks like this:

[DataNath]

You could add a split to columns tool and select split on rows, using the comma as a delimiter.

[IraWatt]

@AliEB what you need to do is have an ID to group each row with in the cross tab tool, that will stop the concatenation.