Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Shinigaloo
Contributor III
Contributor III

add data from excel to an existing table

Hello everyone,

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

Shinigaloo_0-1612452341379.png

Shinigaloo_1-1612452385122.png

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 ?

1 Reply
Taoufiq_Zarra

@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

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉