This content has been marked as final. Show 3 replies
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: CompCode||Excel: CompCode|
After concatenation on QV, I get this loading the Excel data 1st.:
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.