Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Web Page File

Vicky92
7 - Meteor

Hi Team,

 

I have downloaded the file from website. I have to use the same for my working.

 

Can you please help me to get the data in input format/usuable format.

 

While using the Input data, it showing the error as "

Error when Reading in .xls Files - Error opening connect string: Microsoft Access Database"

 

Attaching working file for refernce. 

6 REPLIES 6
Vicky92
7 - Meteor

Vicky92_0-1752420937061.png

 

Format coming as Web Page

KGT
13 - Pulsar

This sounds like the webpage has been saved, not a file downloaded from the webpage. The file has not attached and so I can't confirm.

 

Also, is there another format other than xls? Microsoft has not supported XLS for several years now, and so if there is another format available, then that will be better for you.

Vicky92
7 - Meteor

Hi Team, I want to convert different dates into one format of date.

 

File Uploaded for your your reference.

 

Kindly note that one column has different format of dates while the required output need only one format of date.

 

Also note that format of input date is currently "STRING". Request you to pls help with suitable formula.

caltang
17 - Castor
17 - Castor

Don't think your question is related to your main post, but I did something for you.

 

image.png

 

So far I have seen your scenarios laid out, but there are some scenarios which you need to flag out and test yourself. For instance, 09/08/2025 - is it 8th September 2025 or 9th August 2025? How can you tell from the date itself if it is not consistent?

 

You need a few more flags or data points to make that call. It is not straightforward to convert if you have scenarios like that @Vicky92 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Gaurav_Dhama_
12 - Quasar

Try this macro, I am using regex to identify the format and then format the dates accordingly. 

Note that it follows the hierarchy month-day-year > year-month-day> day-month-year

What this means is, if you have a date say 08-02-2025, it is going to pick 08 as month based on the hierarchy.

Labels
Top Solution Authors