topic Re: Joining tables in QlikView

Joining tables

danielnevitt — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Joining tables

prma7799 — Thu, 18 May 2017 09:56:55 GMT

You can change datatype .....

or please share some data...

Re: Joining tables

danielnevitt — Thu, 18 May 2017 10:00:54 GMT

Thanks for the reply.

How can I change the data type?

RECEIVE_PARTY_NO is SQL Numeric and TGTKEY1 is SQL Varchar

Regards,

Daniel

Re: Joining tables

prma7799 — Thu, 18 May 2017 10:04:37 GMT

Load

RECEIVE_PARTY_NO ,

Num(TGTKEY1) as TGTKEY1

from .....

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

Re: Joining tables

prieper — Thu, 18 May 2017 10:08:31 GMT

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

Re: Joining tables

fashid — Thu, 18 May 2017 10:14:54 GMT

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

Re: Joining tables

danielnevitt — Thu, 18 May 2017 16:27:33 GMT

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

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

Regards,

Daniel