NEED HELP WITH CALENDAR

hello Alteryx experts,

I have tons of csv files with tons of records and I want to indicate whether those records are Sat/Sun or public holiday

here is the issue:

we could only find the date from those records so I guess we might need to manually generate those calendar records and then map with those csv files one-by-one? is there an easier to do solve this problem?

Apart from that, is it possible to ex-large the width of one specific column by using table tool? I try to customize the size but it applies to all columns which I actually want to apply on one specific column only once it outputs in an excel format.

thanks once again!

Accepted answers

RobertOdera

Hi, @Jimmylee4real

Thanks for clarifying.

It sounds like you want to manipulate the Header, which isn't necessarily synonymous with a column-width treatment.

Try this.

In addition to the suggestions already made regarding column configuration, you might need to set Table Width to Fixed instead of the Percentage default.

It's more helpful if you can attach a sample of the current state and the desired state to help you solution.

Meanwhile, you might find the following links helpful:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Getiing-all-the-Outputs-in-1-Excel-Sheet/m-p/585358/highlight/true#M129327

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Reporting-Tool-Unable-to-align-multiple-Tables/m-p/575894#M126816

Cheers!

All comments

Emil_Kos

Hi,

regarding the holidays there are some solutions available online please check this topic:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Holiday-and-Date-Data-Set-Builder/td-p/388592

To identify weekend make sure you have the data in the date-time format and please check the formula below:

DateTimeFormat([Post Date],"%a")

According to this topic, it should help:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Filtering-Records-on-Weekdays-and-Weekends/td-p/560949

Answer to the last question is yes. Please find the workflow attached.

Basic table.yxmd

RobertOdera

Hi, @Jimmylee4real

Credit to @Emil_Kos for the column formatting example.

I would only have added somce specificity: Basic Table Tool > Select Column configuration > set Width to desired Fixed inches.

Please see the attached worklfow example (US Public Holidays 2019 - 2023) regarding your Calendar - Tag Holiday, Sat, Sun question.

I've assumed the first tag is Holiday, then Sat or Sun else is a Weekday.

Please Like + mark as acceptable solution if this works for you. Cheers!

For_Jimmylee4real_Calendar.yxmd

Jimmylee4real

hello there,

Regarding the column formatting issue, I try to en-large the Width so the header will be more visible but it doesn't change anything even after re-setting in the Basic Table Tool. thanks

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703