Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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