Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
danielnevitt
Creator
Creator

Joining tables

Hi,

I am trying to join two tables together.  The field in table 1 is type SQL Numeric (2) and the field in table 2 is SQL Varchar (12).

How can I standardise them in order to  be able to join?

Thanks,

Daniel

6 Replies
prma7799
Master III
Master III

You can change datatype .....

or please share some data...

danielnevitt
Creator
Creator
Author

Thanks for the reply.

How can I change the data type?

RECEIVE_PARTY_NO is SQL Numeric and TGTKEY1 is SQL Varchar

Regards,

Daniel

prma7799
Master III
Master III

Load

RECEIVE_PARTY_NO ,

Num(TGTKEY1) as TGTKEY1

from .....



Or  please send some that for more idea....

prieper
Master II
Master II

You may add preceding LOAD to the SQL-Command, giving you the chance to use all QV-formulas and -expressions,like:

Table1:

LOAD

*,

NUM(Keyfield, '000000000')                    AS %Key;

SQL SELECT * ......

And similar with the other table.

Peter

fashid
Specialist
Specialist

Hi ,

Create a qvd of the tables ,Since qlikview has only two datatypes(numeric, text) Make both of the numeric and then perform a join or a link between the tables .

Regards,

Nadeem

danielnevitt
Creator
Creator
Author

Thank for the replies.  The solution I opted for was:

(convert(varchar,bi.RECEIVE_PARTY_NO) = cm.TGTKEY1)

Regards,

Daniel