Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Data_Model

Hello all,

Please find below attached QVF and data source.

I am trying to achieve below output.

  

posting_idcountry
551410BN
551410IR
551410TH
551410TH
551410IN
551410UA
551410IN
551410Canada
1 Solution

Accepted Solutions
bwisealiahmad
Partner - Specialist
Partner - Specialist

Hi,

A concatenate statement could create that. The real question is what are you trying to do with the data?

Data:


LOAD

    posting_id,

    country

FROM [lib://Desktop/clients_data.xlsx]

(ooxml, embedded labels, table is Sheet1);


Concatenate (Data)


LOAD

    posting_id,

    country

FROM [lib://Desktop/newtenders_data.xls]

(biff, embedded labels, table is tenders$);


Capture.PNG

Best,¨

Ali A

View solution in original post

1 Reply
bwisealiahmad
Partner - Specialist
Partner - Specialist

Hi,

A concatenate statement could create that. The real question is what are you trying to do with the data?

Data:


LOAD

    posting_id,

    country

FROM [lib://Desktop/clients_data.xlsx]

(ooxml, embedded labels, table is Sheet1);


Concatenate (Data)


LOAD

    posting_id,

    country

FROM [lib://Desktop/newtenders_data.xls]

(biff, embedded labels, table is tenders$);


Capture.PNG

Best,¨

Ali A