Q1 | Q2 | Q3 | Q4 | Quarter |
10 | 32 | 45 | 43 | Q4 |
20 | 20 | 45 | 11 | Q4 |
This is the input, I want to select the dynamic quarter based on the value present in the Quarter column' In this example I want only Q4 column as output as it is present in the Quarter column.
Thanks in Advance.
Ayesha
To select the dynamic quarter based on the value present in the "Quarter" column using the Dynamic Select tool in Alteryx, you can follow these steps:
Input Data:
Dynamic Select:
Output Data:
In the Dynamic Select configuration, you can set up a condition based on the values present in the "Quarter" column. For your example, you want to select the columns where the value is "Q4." You can set up a condition like:
This condition will evaluate to "True" for rows where the value in the "Quarter" column is 'Q4', and these columns will be selected by the Dynamic Select tool.
Make sure to configure the Dynamic Select tool with the necessary settings, including specifying the conditions for column selection based on the values in the "Quarter" column. The output will then contain only the columns corresponding to the selected quarter.
@AYESHASIDIKHA @In the dynamic select tool write the below formula
name=“Q”+toString(Ceil(DateTimeMonth(DateTimeToday())/3))
This I have used, But in future years it will not work. If I run the workflow in Jan 2024 then If I am expecting Q4 results we will not get expected output if we use same formula
@AYESHASIDIKHA another option with the analytical app