How to load pivot table data into qlik load editor

[Luffy20]

Hi all,

Country Information

Acquisition Details

Region

Countyr

Name

Code

Model

Company

Company2

Contract ID

For Leased

For Leased 2

For Leased 3

Company3

Contract ID with company

Company4

International

Australia

XYZ Pty Ltd

1234

Leased

DEF

ABX

3196402-1

687.87

N/A

226.78

Included in Leasing

N/A

Aon

International

India

XYZ Pty Ltd

1234

Leased

DEF

ABX

3194923-1

829.02

N/A

379.93

Included in Leasing

N/A

Aon

International

India

XYZ Pty Ltd

1234

Leased

DEF

ABX

3186352-1

712.32

N/A

194.26

Included in Leasing

N/A

Aon

International

India

XYZ Pty Ltd

1234

Leased

DEF

ABX

3179713-2

668.35

N/A

134.13

Included in Leasing

N/A

Aon

International

India

XYZ Pty Ltd

1234

Leased

DEF

ABX

3175579-1

610.50

N/A

268.59

Included in Leasing

N/A

Aon

International

India

XYZ Pty Ltd

1234

Leased

DEF

ABX

3167298-2

650.13

N/A

219.31

Included in Leasing

N/A

Aon

International

India

XYZ Pty Ltd

1234

Leased

DEF

ABX

3166301-4

752.07

N/A

48.76

Included in Leasing

N/A

Aon

International

Australia

XYZ Pty Ltd

1234

Leased

DEF

ABX

3165890-3

646.57

N/A

375.05

Included in Leasing

N/A

Aon

International

China

XYZ Pty Ltd

1234

Leased

DEF

ABX

3143003-3

645.94

N/A

404.8

Included in Leasing

N/A

Aon

International

Australia

XYZ Pty Ltd

1234

Leased

DEF

ABX

3142591-3

709.17

N/A

350.81

Included in Leasing

N/A

Aon

International

Australia

XYZ Pty Ltd

1234

Leased

DEF

ABX

3141347-5

745.90

N/A

355.37

Included in Leasing

N/A

Aon

I have data as shown, i want to show the fields like country,company1,company 2 etc..,

How can i load this data in load editor ,can anyone help me with this

[sbaro_bd · Accepted solution]

Hi @Luffy20 ,

if you load the data from a flat file like xlsx, you just have to define where the header start in your file like this: 

DATA:
LOAD *
FROM [C:\Users\toto\Desktop\Data.xlsx]
(ooxml, embedded labels, header is 1 lines, table is TAB);

Regards.