Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
yogendrawasaika
Contributor
Contributor

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
Partner

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
Partner

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