topic Re: How to Load Different DataType into 1 Column in QV in QlikView

How to Load Different DataType into 1 Column in QV

Tue, 28 Jul 2015 13:23:48 GMT

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

Re: How to Load Different DataType into 1 Column in QV

sorrakis01 — Tue, 28 Jul 2015 13:26:06 GMT

Hi,

try function Text(Oracle: Comp Code)

regards

Re: How to Load Different DataType into 1 Column in QV

sorrakis01 — Tue, 28 Jul 2015 14:05:48 GMT

Hi Fermi,

If it works close the discussion.

Regards

Re: How to Load Different DataType into 1 Column in QV

Tue, 28 Jul 2015 15:57:35 GMT

Thanks a million

It works