Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

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);