topic Re: Table in QlikView

Table

Fri, 19 Jun 2015 08:10:07 GMT

Hello,

How can I change a table as tab1 to tab2?

Thank you very much!

tab1:

Header1	Header 2	Header 3
A	B	C

tab2:

Name	Number
Header1	A
Header2	B
Header3	C

Re: Table

Fri, 19 Jun 2015 08:12:38 GMT

Use the Cross table function in your loading script.

Watch this video it explain how it can be done : Loading Cross Tables

Re: Table

MK_QSL — Fri, 19 Jun 2015 08:13:15 GMT

CrossTable(Name, Number)

Load '1' as Dummy, * Inline

[

Header1, Header2, Header3

A, B, C

];

Drop Field Dummy;

Re: Table

d_koti24 — Fri, 19 Jun 2015 08:21:11 GMT

Hi,

By Using Cross table,you can get this one.

Find the below sample qvw.

Re: Table

settu_periasamy — Fri, 19 Jun 2015 08:28:16 GMT

Hi,

if you want to transpose the data, try the below script.

Tab2:
LOAD @1 as Name,
     @2 as Number
FROM
[https://community.qlik.com/thread/169114]
(html, codepage is 1252, no labels, table is @1, filters(Transpose()));

if you have the source in excel, try the below script.

Directory;
LOAD @1 as Name, 
     @2 as Number
FROM
Book1.xlsx
(ooxml, no labels, table is Sheet1, filters(Transpose()));

Re: Table

MK_QSL — Fri, 19 Jun 2015 09:12:33 GMT