Month Field

[NavinReddy]

Dear All,

I have Data with out month field,

but i have data like jan,feb,mar,apr......... separated fields

how can i merge those fields into one under one month field

i tried with cross table but i am not getting could some one help me do this

i am atteching my Excel please find the attechment

Thanks in Advance

Niranjan

[Anonymous]

I used Crosstable as you can see in the script. Henric Cronström has a great article about it here: The Crosstable Load

I used it twice. One for dollars and one for SQF and then I joined the two resulting tables. At the same time I transformed the name of the month fields to get proper months in QlikView.

Best regards.

[NavinReddy]

Thank you Brono Montenegro