topic Re: Apply Map and looping load in QlikView

Apply Map and looping load

Fri, 29 Aug 2014 02:27:05 GMT

I have a table with common field names stored at different locations like:

www.abc.com/alpha.html

www.abc.com/beta.html

www.abc.com/gamma.html

www.abc.com/delta.html

there are about 110 such links.

I also have a table as follows

A B

1	alpha
2	beta
3	gamma
4	delta

I want to use the loop function like for i = 1 to 110

next;

for i = 1 to 110

Load *,

From

www.abc.com/$(i).html;

How do I use Apply Map (or any other function) in the load script so that it can read the correct link and loop the load?

Re: Apply Map and looping load

Anonymous — Fri, 29 Aug 2014 07:05:00 GMT

can you specify what for you need the applymap?

what do you load from the links? how is the structure of the data to load?

Re: Apply Map and looping load

Fri, 29 Aug 2014 11:57:24 GMT

Sorry my question was not clear.

Well the link contains data in a table format. Which is exactly how I need,

so that part is not a problem.

I can actually run the following script and get the desired result.

Test:

Load *

From

(www.abc.com/alpha.html);

Load *

From

(www.abc.com/beta.html);

Load *

From

(www.abc.com/gamma.html)

Load *

From

(www.abc.com/delta.html);

so on and so forth and it suffices my need.

The problem is there are about 110 such links and hence I will have to add

so many lines of code, I am therefore looking at a sleek code maybe a

Looping script (likeFor i = 1 to 110 next) which will reduce this effort.

I was trying to understand if I can use an ApplyMap to assist in this loop.

Please let me know if you have any questions.

On Fri, Aug 29, 2014 at 12:35 PM, Rudolf Linder <qcwebmaster@qlikview.com>

Re: Apply Map and looping load

Anonymous — Fri, 29 Aug 2014 12:05:51 GMT

I never worked with html files

but can you do

load

from (www.abc.com/*.html)

This way i loadedan loaded several qvds at once in my project

load *

from test????.qvd (as I expect 4 characters after test)

Re: Apply Map and looping load

Fri, 29 Aug 2014 16:46:37 GMT

Thanks for your reply but that is not working. Gives an error, maybe it is

not able to understand the * wild charachter there?

I Even tried % but no fruits.

On Fri, Aug 29, 2014 at 7:06 AM, Rudolf Linder <qcwebmaster@qlikview.com>

Re: Apply Map and looping load

Marcio_Campestrini — Fri, 29 Aug 2014 17:03:48 GMT

Hi Rahul

Try something like this:

URL:

LOAD * INLINE [

id, pagina

1, alpha

2, beta

3, gamma

];

Let noRows = NoOfRows('URL') - 1;

For i = 0 To $(noRows)

LET vPagina = Peek('pagina', $(i), 'URL');

LET vURL = 'www.abc.com/$(vPagina)';

Trace $(vURL);

Next i

The result is:

www.abc.com/alpha

www.abc.com/beta

www.abc.com/gamma

Re: Apply Map and looping load

Fri, 29 Aug 2014 17:31:41 GMT

Awesome it works, I changed it a little at the end

For i = 0 To $(noRows)

LET vPagina = Peek('pagina', $(i), 'URL');

Load *

From 'www.abc.com/$(vPagina)'.html;

and it works. Thanks for your help!!!