Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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: CompCode | Excel: CompCode |
---|---|
001 | 2 |
002 | 3 |
005 | 5 |
004 | 6 |
021 | 10 |
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
Hi,
try function Text(Oracle: Comp Code)
regards
Hi Fermi,
If it works close the discussion.
Regards
Thanks a million
It works