LOAD and TRANFORM the data as mentioned in OUTPUT EXCEL FILE

[lakshmanvepuri]

Hi ,

I have the excel data as given in the Data Sheet.

Need the Output as given below.

Please find the excel sheet( Source ) and Qlikview Script file.

Thanks

L K Vepuri

[BrunPierre · Accepted solution]

Script

MappingSchemaName:
Mapping LOAD QV_SOURCE,
	    DATA_SOURCE
	     
FROM [..\Desktop\SourceFile.xlsx]
(ooxml, embedded labels, table is Data);

DataTable:
LOAD QV_REPORT, 
     QV_SOURCE, 
     DATA_SOURCE,
     TextBetween(QV_SOURCE,'_','.qvw') as DB_TABLE,
     ApplyMap('MappingSchemaName',TextBetween(QV_SOURCE,'_','.qvw'),'test') as Schema_Name
     
FROM [..\Desktop\SourceFile.xlsx]
(ooxml, embedded labels, table is Data)
Where SubStringCount(QV_REPORT,'DLY_MASTER')>0;

Output