Join SQL Select table and Load HTML from Field

Mon, 27 Jun 2016 14:34:47 GMT

Hi,

I have a question regarding linking two tables. The first table is has te following columns:

SQL SELECT kpi_group_id,

ref_date,

CONVERT(res USING utf8) as res,

created_ts

FROM .....;

The column res is longblob (HTML) so I used the File Wizard in order to load the multiple HTML files from Field:

LOAD *

FROM_FIELD

(table name, res)

(html, utf8, embedded labels, table is @1 );

Each HTML file corresponds to a different ref_date but I don't know how to link/join the two tables in order the date to be visible and correct.

Please help!

Thanks in advance!

topic Join SQL Select table and Load HTML from Field in QlikView