Join inline table with existing table?

[#1]

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

[vinieme12]

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

[#3]

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.

[vinieme12]

load the fields as num in both the table loads

Load

NUM(trim(site_num)) as site_num,