Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
yogendrawasaika
New 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
Tags (2)
1 Solution

Accepted Solutions
Partner
Partner

Re: Data_Model

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

1 Reply
Partner
Partner

Re: Data_Model

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