Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Required data for particular month

Maheshp
8 - Asteroid

Hi Team,

 

I am trying to prepare the workflow, as currently we have the below data. In that workflow we want July'24-month data as I am preparing on Jan'24.

 

For Example, I am working on July'24-month data and I want "Currency and July'24-month data" separately via WF. like below. Same if I want to prepare for May'24, it will auto separate the data for which I want.

 

Available data: - 

 

CurrencyMay'24June'24July'24
ILS0.270520.268380.27271
HKD0.128030.128040.12805
KRW0.000730.000720.00072

 

Required data: - 

CurrencyJuly'24
ILS0.27271
HKD0.12805
KRW0.00072

 

Regards,

Mahesh

4 REPLIES 4
PangHC
13 - Pulsar

using dynamic select tool

 

[Name] = "Currency" or

[Name] = datetimeformat("2024-07-01","%B-%y")

 

you may convert the workflow into yxwz and use interactive tool to change the month.

binu_acs
21 - Polaris

@Maheshp using the image.pnganalytical app

 

Maheshp
8 - Asteroid

Hi,

 

Mine is old version, can you please share the workflow in older version to make us understand.

 

Regards,

 

Mahesh

binu_acs
21 - Polaris
Labels
Top Solution Authors