topic Re: change table structure in QlikView

change table structure

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

I have some excel files like this:

code	jan - 2016	feb - 2016	mar - 2016
xxxx	value 1	....	....
yyyy	value 2	....	....
zzzz	value 3	....	....
kkkk	value 4	....	....

I would like to get this situation:

code	month	year	Value
xxxx	jan	2016	value 1
yyyy	jan	2016	value 2
zzzz	jan	2016	value 3
kkkk	jan	2016	value 4

Or something where I can play with months and years.

Can I change the table structure with qlik script?

Thanks

Re: change table structure

micheledenardi — Mon, 29 May 2017 07:44:59 GMT

Use Crosstable function:

CrossTable(period,sales,1)

LOAD code,

[jan 2016],

[feb 2016],

[mar 2016]

FROM

(ooxml, embedded labels, table is Foglio1);

Re: change table structure

Anonymous — Mon, 29 May 2017 08:33:57 GMT

Yes, you can change the table structure by using Cross table in Qlikview.

Hope it helps!!

Re: change table structure

Anil_Babu_Samineni — Mon, 29 May 2017 08:47:13 GMT

Like this?

Script:

Sample:

CrossTable(DateField, Values)

LOAD code,

[jan - 2016],

[feb - 2016],

[mar - 2016]

FROM

[https://community.qlik.com/message/1277004]

(html, codepage is 1252, embedded labels, table is @1);

Inner Join

LOAD code, SubField(DateField,' ',1) as Month, SubField(DateField,' ',-1) as Year, Trim(Values) as Values Resident Sample Where SubField(DateField,' ',1) = 'jan';