In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
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