how to get Output based on Filter condition

HI,

I am using 2 files. one is past years data and another one is current month data. If the month is Jan means, output should come as last year(2021) ( jan to dec ) data has to come .. or else for any other month current month data should come.

Any idea how to achieve this

Developer

Accepted answers

atcodedog05

Hi @Karthick461

Here is the updated workflow with both cases Jan and not Jan. Check and let me know.

Hope this helps : )

last year data (1) (1).yxmd

All comments

csmith11

Not sure I understood the question.

Here's an example of how you might export to different Sheets in the same excel file base on a particular field value.

Dynamic Output.yxmd

Karthick461

I will explain my issue or question.

I have total 2 input source. and one output source. all are csv formats

One input source has historical data. like 2010 to 2021 and other input has current month data.

I need to have one filter condition that will give output in same source(same sheet) based on filter condition

Filter condition is, if month is JAN , output has to show last year complete records from Jan to Dec or else for any month current month data should be there in output

gabrielvilella

Hi @Karthick461, here is my take on this. I made two scenarios within the same workflow, the filter condition is the same on both, just the starting data that is different.

last year data 2.yxmd

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167