0 Replies Latest reply: Jun 27, 2016 10:34 AM by Ivelina Katkova RSS

    Join SQL Select table and Load HTML from Field

    Ivelina Katkova

      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!