Standarizing Date

[Lydieatantra]

Hi Alteryx Team,

Im newby in Alteryx, and i would like to create data with logic to standarizing for public holiday transaction to posted in the next buss date. Lets say the public holiday is on the Saturday and Sunday.

Please refer to my data below :

Current

Transaction Date	Transaction Amount
2020-02-02	100
2020-02-02	150
2020-02-03	200
2020-02-04	100

Expected

(In here, i need to add the transaction amount posted on Saturday & Sunday into next buss day, which is on Monday)

Transaction Date	Transaction Amount	Day	Tran Date_New	Tran Amount_Sum
2020-02-02	100	Sunday	2020-02-03	450
2020-02-02	150	Sunday	2020-02-03	450
2020-02-03	200	Monday	2020-02-03	450
2020-02-04	100	Tuesday	2020-02-04	100

Hopefully i can get the solution.

Thank you.

Lydiea

[BradWerner · Accepted solution]

Hi @Lydieatantra!

You can use a Formula tool to add two days to Saturdays and one day to Sundays and then a Summarize tool to group by the new date field and summarize transaction amounts (see attached workflow for formulas).

Resulting in these totals:

[BradWerner]

Also, if you had a dataset of public holidays, you could push transaction amounts to the next business day regardless of whether it is a weekend.

Just throwing that out there in case it helps you for other holidays.

Take care!

Brad

[huynv96]

Hi @Lydieatantra ,

Hope it helps, I attacked the workflow below

[grazitti_sapna]

Hi @Lydieatantra , I hope this helps.

Thanks.

[Lydieatantra]

Hi @BradWerner ,

Thank you so much for your help, it works perfectly!!

Regards,

Lydiea

[Lydieatantra]

Hi @BradWerner ,

Ok, noted. I will try it if i have the public holiday list.

Thanks a lot for your kind help 🙂

Stay healty,

Lydiea