Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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