topic Re: Multiple columns in to one column and Join in QlikView

Multiple columns in to one column and Join

amithmurali — Sun, 14 Jun 2015 08:22:04 GMT

Hi guys, i am having trouble with this data,

My table is like this. how to work on it to get fields like this "jan 2014 actual" , "jan 2015 Actual , "jan 2015 Budget".

robert_mika — Sun, 14 Jun 2015 23:24:02 GMT

Does this help?

LOAD Units,

F2 as Year,

F3 as Category,

CCJ,

PVT,

MDCLG

FROM

(html, codepage is 1252, embedded labels, table is @1, filters(

Replace(8, left, StrCnd(null)),

Transpose(),

Remove(Row, Pos(Top, 2))

));