Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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