Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
lakshmanvepuri
Creator
Creator

LOAD and TRANFORM the data as mentioned in OUTPUT EXCEL FILE

Hi ,

 

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

lakshmanvepuri_0-1667146410620.png

Need the Output as given below.

lakshmanvepuri_1-1667146427182.png

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

 

Thanks

L K Vepuri

Labels (1)
1 Solution

Accepted Solutions
BrunPierre
Master
Master

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

BrunPierre_2-1667150948223.png

View solution in original post

1 Reply
BrunPierre
Master
Master

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

BrunPierre_2-1667150948223.png