4 XML files with identical structure

Sun, 20 Jul 2014 18:55:56 GMT

Hi everybody.

I have a problem

I have 4 XML files with the same structures, but the data are differents.

I want to store the data of each table of my xml in some QVD but qlikview genere some time identical keys...

For example with the following script, when I put my data of my 4 xml files in the QVD Entity I have identical data in %Key_Entity_55FD346012F79312.

I think it is because I have not only 1 XML...

DO you have an idea to have unique key for all my lines ?

FOR each File in filelist (Root&'\PUBLITEST*.xml')

Entity:

LOAD Id,

ExternalId,

LongName,

EntityTypeId,

EntityTypeName,

ContainerId,

ContainerName,

OrganizationName,

CategoryId,

CategoryName,

CategoryLongName,

CategoryPath,

ParentEntityId,

ParentExternalId,

ParentExtensionEntityId,

ParentExtensionEntityContainerId,

ParentExtensionEntityCategoryId,

Locale,

Action,

%Key_Data_934C399FC545B1C3, // Key to parent table: Data

%Key_Entity_55FD346012F79312 // Key for this table: Data/Entities/Entity

//FROM [$(vchemin)XML SORTANT\PUBLITEST_OPERATION_1.xml] (XmlSimple, Table is [Data/Entities/Entity]);

FROM $(File) (XmlSimple, Table is [Data/Entities/Entity]);

NEXT File

STORE Entity into '$(vchemin)QVD SORTANT\PUBLITEST_OPERATION\Entity.qvd' (qvd);

drop table Entity;

topic 4 XML files with identical structure in QlikView