Select the specific data relevant for the month

[JanaZ]

Hi Everyone,

I am hoping someone could help me with a workflow to select the specific data. 

There are 2 data inputs each time where Sep19 includes September and October data, and Oct19 includes October and Novemver data, however only the October data is relevant. 

The next month will be Oct 19 (Oct +Nov) and Nov 19 (Nov + Dec), but only Nov data is relevant. 

Not sure if I have explain correctly. 

Please refer to the data sample attached. 

Many thanks

Jana

[fmvizcaino]

Hi @JanaZ ,

Attached is an example showing how to do a dynamic filter based in the content of your data. 

The idea was to identify all the months available in your tables and select the middle one. So if we have Sep, Oct and Nov, the workflow will select Oct and filter everything.

Let me know if that works for you.

Best,

Fernando V.

[DiganP]

@JanaZ Here's a workflow that dynamically grabs the overlapping months and gives you the output accordingly. The summarize tool + join tool grabs the overlapping months and the append fields + filter tool separates the months accordingly. 

Attached is the workflow. Does this work for you?

[JanaZ]

Hi Fernando

Are you able to upload the workflow?

thanks

Jana

[JanaZ]

Hi Digan,

Thanks for the solution, however, I am not able to open the YXZP file via my current Alteryx version.

I can only open YXMD file. 

thanks

Jana

[fmvizcaino · Accepted solution]

Hi @JanaZ ,

Sorry, I forgot to upload the example. hahaha My bad!

Attached now! 

Best,

Fernando V.

[JanaZ]

Thank you. 🙂

[DiganP · Accepted solution]

@JanaZ  Attached is the yxmd file! Let me know if this works!

[JanaZ]

Thanks Digan.