add data from excel to an existing table

Shinigaloo — Mon, 26 Jan 2026 16:26:21 GMT

Hello everyone,

i have a table called "Ligne" (see below)

I want to add 3 columns to this existing table from an excel file (see attached file)

How can i do the link between the 2 so that i can have these 3 columns in my table "Ligne "

i've tested with this code but it doesn't worked for me :

//Table Ligne
LIGNE:
LOAD DISTINCT
autonumber(CD_REFCOM_FILS) AS _key_id_call_inv,
autonumber(ID_LIGNE&CD_REFCOM) AS ID_LIGNE,
ID_LIGNE&CD_REFCOM AS _tmp_key_line_calls,
CLIENT_LIGNE,
Numero AS "Numéro interne",
[Numéro SDA] AS "Numéro externe",
ID_SITE,
Site
RESIDENT wLIGNE;
INNER JOIN
LOAD ligne.numero_interne AS "Numéro interne",
ligne.client AS CLIENT_LIGNE,
ligne.sda AS "Numéro externe",
ligne.id_site as ID_SITE,
[label1 (marque)],
[label2 (région)],
[label3 (service)]
FROM
[.\b2g_qvs\Inputs.xlsx]
(biff, embedded labels, table is [Tablib Dataset$]);
Drop table wLIGNE;

can anyone help me ?

Re: add data from excel to an existing table

Taoufiq_Zarra — Fri, 05 Feb 2021 08:49:09 GMT

@Shinigaloo Can you give more details? what you are looking to join ?
or you can also share the other table with the expected result.

Merci

topic Re: add data from excel to an existing table in QlikView

add data from excel to an existing table

Re: add data from excel to an existing table