topic table creation and qvd in QlikView

table creation and qvd

pirotfab — Wed, 25 May 2016 13:58:27 GMT

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 — Wed, 25 May 2016 19:32:41 GMT

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 — Mon, 30 May 2016 07:39:45 GMT

hello,

it's ok

thanks