Joining tables

[danielnevitt]

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

[prma7799]

You can change datatype .....

or please share some data...

[danielnevitt]

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]

Load

RECEIVE_PARTY_NO ,

Num(TGTKEY1) as TGTKEY1

from .....

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

[prieper]

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]

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]

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

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

Regards,

Daniel