Skipping previous month load if it is January

Hi Masters

I have a workflow where I need to calculate the current month value which is obtained by subtracting the previous month YTD from the current month YTD.

By selecting the current date in the interface, the dynamic input pulls automatically the previous month file and makes a join with the current month file.

This works fine for every month but the first month of the year for which there is no previous month data.

Is there a way to add a condition to skip/ignore the dynamic input from previous month (highlighted below) if the selected month is January?

Thanks

Felipe

skip previous month.jpg

Skipping Previous Month load.yxwz

Developer Tools

Input

Date Time

Accepted answers

geraldo

@Felipe_Amancio

An example workflow

Skipping Previous Month load_Rev.yxwz

All comments

jdminton

Try adding a filter after the input file with DateTimeMonth([Current Month]) != 1. Send the true side on through the process. You may need to do something with the false side to pass through a message to the user that there isn't a prior month in the YTD data.

geraldo

@Felipe_Amancio

An example workflow

Skipping Previous Month load_Rev.yxwz

Felipe_Amancio

Thanks Geraldo!. I had to make a small addition to your solution but it showed me how to solve it! Skip previous month2.jpg

prakashkaur189

Agreed, this is the easiest way to do so.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703