Added field and Strait table presentation

[sogloqlik]

Hi,

My code performs a load from an Excel file, and I am adding a column of my own.

For example:

Load

LOAD

AM,
"Start Date",
Task,
"Agency department",
Comments,
"Task With",
"End Date",
"Assigned To",
Status,
Deliverables,
outcome,
"Etimated Hours",
"# of resources"

'TableName’ as  Name // Added Column, not a column in the file.

.....

When I present the data in a Strait Table, it adds a line with the value of the new column with all the other column with Null.

I counted the number of rows in the script with and without the add column and it is the same.

What am I missing?

Regards.

[mpc]

Hi, I've perfom a test with this code:

Ventes:
LOAD
"ID Vente",
"ID Client",
"ID Vendeur",
"ID Véhicule",
"Prix de vente",
"Prix de fabrication du véhicule",
"Coût logistique",
Date("Date de la vente") as "Date de la vente",
Date("Date de récupération du véhicule") as "Date de récupération du véhicule",
'Test' as MyAddedField
FROM [Ventes.qvd]
(qvd);

Here the result in my table:

Can you share the complete script please ? 

Regards 

[sogloqlik]

Hi,

As I wrote, My Data from Excel, not from QVD.

Besides that, My code is the same.

Regards.

[mpc · Accepted solution]

Hi, 

Excel or QVD, the behavior should be the same. 

My code: 

LOAD
ID,
Prix_de_vente,
Marge,
Date_de_vente,
Date_de_paiements,
Client_ID,
Commercial_ID,
Voiture_ID,
'Test' as MyAddedField
FROM [lib://DataFiles/ventes.xlsx]
(ooxml, embedded labels, table is [ventes (1)]);

My result:

Best regards

[sogloqlik]

Problem Solved,

There was an issue with the Excel file.

Thx for the help.