Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Transform and Add a month field in table.

Goodmorning everyone.


I have a table so constructed:


CodicePeriodo, AnnoInizio, MeseInizio, AnnoFine, MeseFIne, Peso_01, Peso_02, Peso_03........Peso_12

     cod01             2016            1             2016         12             10            15           55     ..........   25

     cod02             2015            1             2015         12             21            25           65     ..........   75


I should get a structure like below:


CodicePeriodo, AnnoInizio, MeseInizio, AnnoFine, MeseFIne, Mese, Peso_01

CodicePeriodo, AnnoInizio, MeseInizio, AnnoFine, MeseFIne, Mese, Peso_02

CodicePeriodo, AnnoInizio, MeseInizio, AnnoFine, MeseFIne, Mese, Peso_03

CodicePeriodo, AnnoInizio, MeseInizio, AnnoFine, MeseFIne, Mese, Peso_04

...
CodicePeriodo, AnnoInizio, MeseInizio, AnnoFine, MeseFIne, Peso_12

cod01 2016, 1, 2016, 12 , 1, 10

cod01 2016, 1, 2016, 12 , 2, 15

cod01 2016, 1, 2016, 12 , 3, 55

..

cod01 2016, 1, 2016, 12 , 12, 25

cod02 2015, 1, 2015, 12 , 1, 21

cod02 2015, 1, 2015, 12 , 2, 25

cod02 2015, 1, 2015, 12 , 3, 65

..

cod01 2015, 1, 2015, 12 , 12, 75


"Mese" in a new Field.  The month field must be as follows:

Peso_01  => 1

Peso_02 =>  2

..

..

Peso_12 => 12

Each field Peso_n (1...12)  must match a record with the number of the month, for each CodicePeriodo.

Can you help me build the new table ??


Thank you very much


1 Solution

Accepted Solutions
1 Reply
sunny_talwar

I think you need The Crosstable Load