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
Solved! Go to Solution.
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
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?
Surely you could just add a formula tool on that sums all of the columns that are left at the end?
@AliEB , Do you have an example workflow of where your up to ?
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:
You could add a split to columns tool and select split on rows, using the comma as a delimiter.
@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.