Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Importing txt from web

Neico
7 - Meteor

Hello,

 

I'm having issues to import and properly format the following file:

http://weather.rap.ucar.edu/surface/stations.txt

 

Any suggestions how that could be done are highly appreciated!

7 REPLIES 7
wwatson
12 - Quasar

I pulled this together, I hope it does what you want.

 

wwatson_0-1597514927825.png

 

This would have made for a great weekly challenge 🙂

Neico
7 - Meteor

Thank you very much! This is a great start and definitely is helpful.

 

It just appears that the data stops at "Mexico". Any idea why not the whole data is imported?

wwatson
12 - Quasar

It looks like the countries after Mexico don't have the title row starting CD.

 

An additional parse would be required for those countries.

 

Can you handle that or do you need help with it?

wwatson_0-1597584168786.png

 

wwatson_1-1597584212704.png

 

Neico
7 - Meteor

I'm not sure how to account for that. Would be great if you could show. Thank you!

ImadZidan
12 - Quasar

Hello @Neico ,

 

I have looked at @wwatson  workflow and did a little change to the formula.

 

Check if it does the job.

 

I hope its ok with you @wwatson .

 

I hope it helps.

wwatson
12 - Quasar

@Neico please mark my solution as an accepted solution as well as the one submitted by @ImadZidan . It contains 95% of the solution and I just didn't have time to make the minor adjustment required.

 

Thanks

Neico
7 - Meteor

of course, you're absolutely right! Thanks again!

Labels