topic Join inline table with existing table? in QlikView

Join inline table with existing table?

Sun, 22 Jan 2017 15:04:31 GMT

Hi all,

I have a site table with site_num. i want to create another inline table with following data:

trend:

load * inline

[

site_num, temp_rate, timestamp

501,0.01,1/1/2017

501,0.001,5/2/2017

501,0.01,6/3/2017

501,0.02,2/1 /2017

501,0.002,3/2/2017

501,0.02,4/3/2017

];

how should I join the site_num of inline table to site_num of site table? Please note that in site table, there is only one entry for site_num=501

Re: Join inline table with existing table?

vinieme12 — Sun, 22 Jan 2017 15:19:17 GMT

if the field names are same Qlikview automatically creates the association

If you want to learn about joins

read this post

Understanding Join, Keep and Concatenate

Re: Join inline table with existing table?

Sun, 22 Jan 2017 16:01:19 GMT

The fields are the same name but data types dont match. the inline table takes the data type- number. if i try to changeit with text(site_num), then the automatic association does not take place.

Re: Join inline table with existing table?

vinieme12 — Sun, 22 Jan 2017 16:43:29 GMT

load the fields as num in both the table loads

Load

NUM(trim(site_num)) as site_num,