Discussion board where members can get started with QlikView.
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?
You can change datatype .....
or please share some data...
Thanks for the reply.
How can I change the data type?
RECEIVE_PARTY_NO is SQL Numeric and TGTKEY1 is SQL Varchar
Num(TGTKEY1) as TGTKEY1
Or please send some that for more idea....
You may add preceding LOAD to the SQL-Command, giving you the chance to use all QV-formulas and -expressions,like:
NUM(Keyfield, '000000000') AS %Key;
SQL SELECT * ......
And similar with the other table.
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 .
Thank for the replies. The solution I opted for was:
(convert(varchar,bi.RECEIVE_PARTY_NO) = cm.TGTKEY1)