Automatic Current month and year creation below the existing data

Hi All,

I'm new to this platform. I have year and month column of 2019 in my excel sheet and I want to create a new row which can show current year and current month with existing data. I want to automate this process,

so as and when new month comes it should create new row and union it below the existing data.

Input fileOutput file required

Topic of Interest

Accepted answers

joshuaburkhow

Hi @Pushkar

There are actually a ton of ways to do this in Alteryx. I'll show you one....

The goal here is to get whatever dates you have into the Alteryx date format. From there you can pretty much do anything you need!

Hope this helps! If it does please make sure to mark solved so that others on the community can find it 🙂

All the best!

Joshua

Add a month.yxmd

All comments

joshuaburkhow

Hi @Pushkar

There are actually a ton of ways to do this in Alteryx. I'll show you one....

The goal here is to get whatever dates you have into the Alteryx date format. From there you can pretty much do anything you need!

Hope this helps! If it does please make sure to mark solved so that others on the community can find it 🙂

All the best!

Joshua

Add a month.yxmd

Pushkar

joshuaburkhow

HI, Thank you for sharing workflow even i was thinking on the same logic but i was skeptical whether in next month (Feb 2020) will it append data below Jan 2020 without changing input file.

Will you verify my logic?

once again thank you for quick reply.

test workflow.yxzp

Pushkar

yeah, Thank you so much!!!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703