NEED HELP WITH CALENDAR

[Jimmylee4real]

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!

[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...

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-Week...

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

[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!

[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

[RobertOdera · Accepted solution]

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-She...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Reporting-Tool-Unable-to-align-multipl...

Cheers!

[RobertOdera]

@Jimmylee4real  you're most welcome.

Thanks for the feedback! Cheers.