Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to Load Different DataType into 1 Column in QV

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

1 Solution

Accepted Solutions
sorrakis01
Not applicable

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

Hi Fermi,


If it works close the discussion.


Regards

3 Replies
sorrakis01
Not applicable

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

Hi,

try function Text(Oracle: Comp Code)

regards

sorrakis01
Not applicable

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

Hi Fermi,


If it works close the discussion.


Regards

Not applicable

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

Thanks a million

It works