how to load this table into qlikview

[Frank_Hartmann]

Hi community,

Is there any chance to get the attached table loaded into Qlikview?

Thanks for helping

[Frank_Hartmann]

I think i got the solution.

After choosing the table in QV script, press "enable transformation step", then go to "Rotate" and click "Transpose". After that go to "Fill", mark first column and click"Fill" Button, click"Cell Condition", click OK, click OK. Click Next, Choose Cross Table, Qualifier Fields =2, Attribute Field = Code, Data Field = Data, click OK, click Next, click Finish. Reload script.

That worked for me!

If there is a better way, please let me know

[sunny_talwar · Accepted solution]

Is this what you are looking for?

Table:

CrossTable(Region, Data, 2)

LOAD [PRODCOM Code],

     Median,

     EU28 & '|' & F4 as EU28,

     EU27 & '|' & F6 as EU27,

     Belgium & '|' & F8 as Belgium,

     Bulgaria & '|' & F10 as Bulgaria,

     [Czech Republic] & '|' & F12 as [Czech Republic],

     Denmark & '|' & F14 as Denmark,

     Germany & '|' & F16 as Germany,

     Estonia & '|' & F18 as Estonia,

     Ireland & '|' & F20 as Ireland,

     Greece & '|' & F22 as Greece,

     Spain & '|' & F24 as Spain,

     France & '|' & F26 as France,

     Italy & '|' & F28 as Italy,

     Cyprus & '|' & F30 as Cyprus,

     Latvia & '|' & F32 as Latvia,

     Lithuania & '|' & F34 as Lithuania,

     Luxembourg & '|' & F36 as Luxembourg,

     Hungary & '|' & F38 as Hungary,

     Malta & '|' & F40 as Malta,

     [The Netherlands] & '|' & F42 as [The Netherlands],

     Austria & '|' & F44 as Austria,

     Poland & '|' & F46 as Poland,

     Portugal & '|' & F48 as Portugal,

     Romania & '|' & F50 as Romania,

     Slovenia & '|' & F52 as Slovenia,

     Slovakia & '|' & F54 as Slovakia,

     Finland & '|' & F56 as Finland,

     Sweden & '|' & F58 as Sweden,

     [The United Kingdom] & '|' & F60 as [The United Kingdom],

     Croatia & '|' & F62 as Croatia,

     Iceland & '|' & F64 as Iceland,

     Norway & '|' & F66 as Norway,

     Turkey & '|' & F68 as Turkey,

     [Bosnia and Herzegovina] & '|' & F70 as [Bosnia and Herzegovina],

     Montenegro & '|' & F72 as Montenegro,

     [FYRO Macedonia] & '|' & F74 as [FYRO Macedonia],

     Serbia & '|' & F76 as Serbia

FROM

manufactured_goods_EU.xls

(biff, embedded labels, table is [Unit Value$])

Where Len(Trim([PRODCOM Code])) > 0;

NewTable:

NoConcatenate

LOAD [PRODCOM Code],

     Median,

     Region,

     SubField(Data, '|', 1) as [Unit Val],

     SubField(Data, '|', 2) as Ratio

Resident Table

Where Data <> '|';

DROP Table Table;