topic Conditional LOAD in QlikView

Conditional LOAD

Mon, 22 Jul 2013 14:45:50 GMT

Hi. I have 2 types of exel files. One type contents direct tables, another type contents transposed tables.

I can open each one in macro by excel API to check is table direct or transope, then make script by macro and after it load.

But it seems to me this is too difficult for such a simple problem

Is there another solution?

Maybe something like

Load * from [2.xlsx](ooxml, embedded labels, table is Лист1, if( value = 1, filters(Transpose())); ?

marcus_sommer — Mon, 22 Jul 2013 15:09:57 GMT

You could check a fieldname/fieldvalue before you load the data completely. You need only a unique field.

Check:

Load @1 as Check From .... where rowno() = 1;

let vCheckLoad = if(peek('Check', 0, 'Check') = 'ANY', 'direct', 'transposed');

if '$(vCheckLoad)' = 'direct' then

Load .... first

else

Load .... second

end if

- Marcus

Tue, 04 Mar 2014 04:37:43 GMT

Thank you!