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

[#1]

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

[manojkulkarni]

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

[#3]

Hi Manoj

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

[manojkulkarni]

Table1:

LOAD

*,filebasename() AS DataFileName

FROM

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

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

Drop Table Table1;

[#5]

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

[renjithpl]

* 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.

[#7]

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.

[#8]

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

[manojkulkarni]

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.