Star is *

soloeeeoff — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I tried "Star is * ". But I could not attain what i have expected.

Please can any one help me..

QUALIFY *;
STAR is % ;
tab1:
LOAD ID,
College,
Dept,
Section,
Name,
Mark1,
Mark2,
Mark3
FROM
[62_Star.xlsx]
(ooxml, embedded labels, table is Sheet1);
tab2:
load % Resident tab1;

Re: Star is *

swuehl — Fri, 16 Sep 2016 18:55:52 GMT

Star is %;

is changing the wildcard for field values, not field names in a LOAD statement (here, * is used to reference all fields from the input table).

Star is %;

LOAD * INLINE [

Field1, Field2,

A, 1

A, 2

B, %

C, 3

];

Now create list boxes for Field 1 and Field2, you will notice that Field2 only shows values 1 to 3, not a '%' symbol.

Regardless what you select in Field 2, value 'B' in Field 1 will be possible, because of it's 'Wildcard' use.

Hope this explains a little bit the 'star is ...' statement (though I almost never use it, AFAIR, I've had seen some side effects, then dropped it from my daily usage).

Stefan

topic Re: Star is * in QlikView

Star is *

Re: Star is *