Variable in URL ??

[Michiel_QV_Fan]

Hi all,

I'm extracting data from text on URL's. For instance, this URL.

(http://www.wunderground.com/weatherstation/WXDailyHistory.asp?ID=IFRIESLA37&graphspan=custom&month=1&day=1&year=1996&monthend=12&dayend=31&yearend=2010&format=1)

I want to extract a few 1000 different datasets, all based on this URL. The only thing that changes is the part "ID= ".

I would like to use 'for each next' or something like that to have the ID part variable so I only have 1 line of code.

Is this possible?

Your help is much appreciated.

[sparur · Accepted solution]

Michiel, as I promised

I checked it and fixed it 🙂

see my example in attachment...

[Michiel_QV_Fan]

Absolutely GREAT!!!!!!!!!!!!!!!!!!

Thanks for your help!!

[Michiel_QV_Fan]

I'm now using Qlikview 10.

The set url variables aren't needed at all.

Just replace the URL parts with variables and Qlikview creates the correct URL's.

FROM[http://www.blablablabla$(variable)blablalbalbalbla$(variable2)blablabla.html]

Works great.