Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
cmano
Creator
Creator

Load multiple excel files with multiple sheets script

Hello guys i have a question.

I have 2 different excel books (Belgium & Czech Republic.xlx)

Each xlx file have 3  sheets ( IGT,SPL & FRN).

  • For IGT sheet (columns are): 
Date
I.G.T.
Basket

A/T

 

Material description
Process order
Inspection lot
Order/Item
Material
Quantity
Characteristic
Min
Max
Value
Customer code
Customer description
Country
  • For SPL sheet (columns are): 
Date
Basket
No Coil
Material description
Process order
Inspection lot
Order/Item
Material
Quantity
Characteristic
Min
Max
Value
Customer code
Customer description
Country

 

  • For FRN sheet (columns are): 
No Coil
Material description
Process order
Inspection lot
Order/Item
Material
Quantity
Characteristic
Min
Max
Value
Customer code
Customer description
Country

 

They told me that QlikView creates synthetic keys and i have notice problem with data calculation.

What is have to do to load the data correctly?

Also i have problem export from the date (year, month,day , etc.) the Date form is DD-MM-YYYY.

Thank you so much.

Labels (1)
1 Reply
QFabian
Specialist III
Specialist III

Hi @cmano , if you have 3 tables, but with the same fields , but some of the field name are not equal, yo can rename the fioelds to get the same fields structure, and if there are fields not in the 3 source tables, yo can create that missing fields, for example :

 

Load

Date   as Date,
I.G.T.   as I_G_T,
Basket  as Basket,

Min,
Max,

..... normalize rest of fields

FROM IGT;

 

Load

Date  as Date,

'' as I_G_T,

Basket as Basket,

Min,
Max,
..... normalize rest of fields

FROM SPL;

Load

Date  as Date,

'' as I_G_T,

Basket as Basket,

Min,
Max,
..... normalize rest of fields

FROM

FRN;

Please check the help about it :

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes...

Example 2 – Appending multiple sets of data to a target table using implicit concatenation

Implicit concatenation will take place between any two tables that are loaded with identically named fields

QFabian