Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to make two different excel columns into one

Dears,

Need your help in Making two different columns into one as attached below scrrenshots.

Format.PNG

Thanks

Akhil

1 Reply
MVP
MVP

Re: How to make two different excel columns into one

May be this

Table:

LOAD ABC,

    [Actual 2001],

    [Actual 2002],

    [Budget 2003]

FROM

[..\..\Downloads\Data.xlsx]

(ooxml, embedded labels, table is Sheet2);

Concatenate (Table)

LOAD xyz as ABC,

    [Actual 2001],

    [Actual 2002],

    [Budget 2003]

FROM

[..\..\Downloads\Data.xlsx]

(ooxml, embedded labels, table is Sheet3);