Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
hello,
it's ok
thanks