topic Re: What is the Use Of *(Star) Symbol in the qlikview? in QlikView

What is the Use Of *(Star) Symbol in the qlikview?

Fri, 13 Feb 2015 06:15:10 GMT

Hi All

I have some doubts that why do we use * symbol in the .XML ?

1)Mainly Why Do we Use these * Symbol in the Scripting the data?

2)In which Condition do we Use these symbol?

Mainly I have Loaded Huge data like 33 stores of data in each tab i have loaded in the scripting when i am reloading that all data is showing as Synthetic key in the Table View.That Data Should linked.

So Please help me.

I hope Some one will Answer.

Thanks In Advance

Re: What is the Use Of *(Star) Symbol in the qlikview?

manojkulkarni — Fri, 13 Feb 2015 06:28:49 GMT

case 1: we use to load all the fields from table/source file

case 2: loading multiple files from a single directory of same type

Re: What is the Use Of *(Star) Symbol in the qlikview?

Fri, 13 Feb 2015 06:31:46 GMT

Hi Manoj

Thanks for reply can you tell me or show me the examples how to load all data into single file?

Re: What is the Use Of *(Star) Symbol in the qlikview?

manojkulkarni — Fri, 13 Feb 2015 06:37:01 GMT

Table1:

LOAD

*,filebasename() AS DataFileName

FROM

<<Path Of Source Files>>\*.xlsx;

Store Table1 into <<QVD Store Path>>Table1.qvd (QVD);

Drop Table Table1;

Re: What is the Use Of *(Star) Symbol in the qlikview?

Fri, 13 Feb 2015 06:42:32 GMT

Hi Manoj

I have the data like this for all 33 stores .Same as i Mention here below so could Please Help me as per the data given below

// Start of [Barking and Dagenham.xml] LOAD statements

EstablishmentDetail:

LOAD FHRSID,

LocalAuthorityBusinessID,

BusinessName,

BusinessType,

BusinessTypeID,

AddressLine2,

AddressLine4,

PostCode,

RatingValue,

RatingKey,

RatingDate,

LocalAuthorityCode,

LocalAuthorityName,

LocalAuthorityWebSite,

LocalAuthorityEmailAddress,

SchemeType,

AddressLine1,

AddressLine3,

[Geocode/Longitude] as Longitude,

[Geocode/Latitude] as Latitude,

[Scores/Hygiene] as Hygiene,

[Scores/Structural] as Structural,

[Scores/ConfidenceInManagement] as ConfidenceInManagement,

[RatingDate/xsi:nil] as [xsi:nil],

%Key_FHRSEstablishment_6B08CFAA9E1E09FA // Key to parent table: FHRSEstablishment

FROM [*.xml] (XmlSimple, Table is [FHRSEstablishment/EstablishmentCollection/EstablishmentDetail]);

FHRSEstablishment:

LOAD [xmlns:xsi],

[Header/ExtractDate] as ExtractDate,

[Header/ItemCount] as ItemCount,

[Header/ReturnCode] as ReturnCode,

%Key_FHRSEstablishment_6B08CFAA9E1E09FA // Key for this table: FHRSEstablishment

FROM [*.xml] (XmlSimple, Table is [FHRSEstablishment]);

// End of [Barking and Dagenham.xml] LOAD statements.

Second Tab Data

/ Start of [Barnet.xml] LOAD statements

EstablishmentDetail:

LOAD FHRSID,

LocalAuthorityBusinessID,

BusinessName,

BusinessType,

BusinessTypeID,

AddressLine1,

PostCode,

RatingValue,

RatingKey,

RatingDate,

LocalAuthorityCode,

LocalAuthorityName,

LocalAuthorityWebSite,

LocalAuthorityEmailAddress,

SchemeType,

RightToReply,

[Geocode/Longitude] as Longitude,

[Geocode/Latitude] as Latitude,

[Scores/Hygiene] as Hygiene,

[Scores/Structural] as Structural,

[Scores/ConfidenceInManagement] as ConfidenceInManagement,

[RatingDate/xsi:nil] as [xsi:nil],

%Key_FHRSEstablishment_6B08CFAA9E1E09FA // Key to parent table: FHRSEstablishment

FROM [*.xml] (XmlSimple, Table is [FHRSEstablishment/EstablishmentCollection/EstablishmentDetail]);

FHRSEstablishment:

LOAD [xmlns:xsi],

[Header/ExtractDate] as ExtractDate,

[Header/ItemCount] as ItemCount,

[Header/ReturnCode] as ReturnCode,

%Key_FHRSEstablishment_6B08CFAA9E1E09FA // Key for this table: FHRSEstablishment

FROM [Barnet.xml] (XmlSimple, Table is [FHRSEstablishment]);

// End of [Barnet.xml] LOAD statements

Re: What is the Use Of *(Star) Symbol in the qlikview?

renjithpl — Fri, 13 Feb 2015 06:47:13 GMT

* is for all fields.

When you use *, you cannot alias the fields thats when you get syn keys,

Its good to list out the filed names and rename them as per the requirement.

Re: What is the Use Of *(Star) Symbol in the qlikview?

Fri, 13 Feb 2015 07:00:50 GMT

Hello Manoj

Can You Help With these data please just i want the example with these data .Can you show how to add the Star Symbol at which place of the data.

Re: What is the Use Of *(Star) Symbol in the qlikview?

Fri, 13 Feb 2015 07:11:17 GMT

Hi Harish

1. In general "*" implies all the occurrences , we can also use it in your expression .eg Match(fieldName,'S*'), this will give you all the result that starts with the letter S.

2. secondly we mostly use it in section access, but in sometimes doesn't bring back the correct result, so we first use STAR IS *; then define it in your section access.

This is just an overview, hope is helps

Re: What is the Use Of *(Star) Symbol in the qlikview?

manojkulkarni — Fri, 13 Feb 2015 07:11:39 GMT

As mentioned by Renjith Pl ,

You cann't put alias column name for existing fields. when used * in loading all fields

We can define fields in load statement and use * after FROM statement in Load script. Again this will work only when you have files in the same format.