Keep previous month and delete others

Hi all,

I have an excel table with data ordered by month. I now want Alteryx to only keep the column that shows the previous month (e.g. if today is the 3rd of april I only want the data for march) and to delete the other months (but of course keep the first few columns).

Does anybody know how to do that?

Do I have to use a formula or a filter for that?

I also attached a file to show how the table more or less looks.

Thanks!

Screenshot Alteryx.pdf

Accepted answers

mceleavey

Hi @Lu26 ,

I've attached the workflow for you.

Basically, I've isolated the generic columns, 1-4, and the dynamic columns are the ones related to months. I've then pivoted the data, created the calculation for current month-1, joined it to isolate the column that relates to that month, joined it back, and then added it to the generic columns.

Hope this helps,

Solution.yxmd

All comments

mceleavey

Hi @Lu26 ,

I've attached the workflow for you.

Hope this helps,

Solution.yxmd

Lu26

mceleavey

It worked perfectly fine!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703