3 Replies Latest reply: Jul 28, 2015 11:57 AM by Femi Adeniyi RSS

    How to Load Different DataType into 1 Column in QV

    Femi Adeniyi

      Hi All,

      I ran into this scenario while SIBing a prospect.

      They have data in Oracle and Excel to merge as a single table in QV. Sure this given! However, a column common to both data source store strings in Oracle and numbers in Excel. See table below:

      Oracle Column:

      Oracle: CompCodeExcel: CompCode
      0012
      0023
      0055
      0046
      02110

      After concatenation on QV, I get this loading the Excel data 1st.:

      CompCode
      2
      3
      5
      6
      10
      1
      4
      21

      This is not okay because 001 is not same as 1 and it ll give data-link issues.

       

      How do can I get QV to load the data as it is in the tables without re-formatting it?


      Many thanks in advance.

      Femi