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;