Select the specific data relevant for the month

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

input 1 - Sep19.csv

input 2 - Oct19.csv

Finished.csv

Workflow

Accepted answers

fmvizcaino

Hi @JanaZ ,

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

Attached now!

Best,

Fernando V.

2019-11-24 Select the specific data relevant for the month.yxmd

DiganP

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

Month Workflow.yxmd

All comments

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.