Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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") 😉