1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| FOR each File IN filelist ('D:\Qlickview\ENTREPOT\Referentiel\*.qvd')
REFERENTIEL1:
LOAD
Discriminator AS Emplacement_qvd,
FileBaseName(Discriminator) AS Nom_qvd,
FileBaseName( $(File)) AS @clef_Nom_qvd
FROM $(File) (XmlSimple, Table is [QvdTableHeader/Lineage/LineageInfo]);
REFERENTIEL2:
LOAD upper(FileName(CreatorDoc)) AS @clef_Nom_qvd_associé,
FileBaseName($(File)) AS @clef_Nom_qvd,
//QvBuildNo,
upper(CreatorDoc) AS Emplacement_referentiel,
replace(upper(CreatorDoc), upper('D:\Qlickview\ETL\Referentiel\'),'') AS Nom_referentiel,
FileBaseName(CreatorDoc) AS Nom_qvd_sortie,
// CreateUtcTime,
// SourceFileSize,
TableName AS Nom_dernière_table
// RecordByteSize,
// NoOfRecords,
// Offset,
// Length,
// %Key_QvdTableHeader_B94FCCAC68ED3E20 // Key for this table: QvdTableHeader
FROM $(File) (XmlSimple, Table is [QvdTableHeader]);
next File |
Partager