1 Reply Latest reply: Aug 21, 2018 3:14 AM by Ali Ahmad RSS

    Data_Model

    Yogendra Wasaikar

      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
        • Re: Data_Model
          Ali Ahmad

          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