How to select the column based on the value present in the column using dynamic select?

Question

Q1Q2Q3Q4Quarter10324543Q420204511Q4

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

binu_acs · Answer

@AYESHASIDIKHA another option with the analytical app

Dynamic_Select_241123.yxwz

CoG · Answer

Here you are! I believe this meets your requirements.

Sample Workflow.yxmd

AYESHASIDIKHA · Answer

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