Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi,
By Using Cross table,you can get this one.
Find the below sample qvw.
Use the Cross table function in your loading script.
Watch this video it explain how it can be done : Loading Cross Tables
CrossTable(Name, Number)
Load '1' as Dummy, * Inline
[
Header1, Header2, Header3
A, B, C
];
Drop Field Dummy;
Hi,
By Using Cross table,you can get this one.
Find the below sample qvw.
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()));