table creation and qvd

[pirotfab]

Hello

Please find attached an example intervalmatch for me to assign each account to a business.

Know how to create a qvd,  a single table?

Thanks

Note: Edited by moderator to make title English.

[swuehl]

You can JOIN your tables to create a single table:

Maybe like

COMPTES:

LOAD COMPTES,

     [REGROUPEMENT 1],

     [REGROUPEMENT 2],

     [REGROUPEMENT 3],

     CODE

FROM

(ooxml, embedded labels, table is COMPTES);

METIERS:

LOAD SECTION,

     LIBELLE,

     debut,

     fin

FROM

(ooxml, embedded labels, table is METIERS);

IntervalMatch:

INNER JOIN

IntervalMatch (CODE) LOAD

  debut,

     fin

Resident METIERS;

LEFT JOIN (COMPTES)

LOAD * RESIDENT METIERS;

DROP TABLE METIERS;

[pirotfab]

hello,

it's ok

thanks