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!
