excel loading

[Anonymous]

Hi

Here is my script , somehow i get 2 columns for project_name and location , basically i want , 1 project_name and 1 location,

i have data in table1 , and i have excel sheet which has some additional values for Project and Location to be added to the table, as the table in databse did not have these values i thought of loading them in qlikview itself

but , after the reload with below scrit , i get 2 columns in the application one from table and the other from excel sheet , how do i avaoid this?

Calender:
load
Month(Month) AS [Month #],
Monthname(Month) AS [Month_Year],
Year(Month) AS Year,*;

Table1:
sql select rumi_device, project, location, trunc(hour) as Day, trunc(hour,'month') as "Month"

---- all my code
from table1

;

LEFT JOIN(table1)

LOAD Location,
SiteDesignator,
SiteName
FROM
C:\Users\c_rsrira\Desktop\rumi_meta_mappings.xlsx
(ooxml, embedded labels, table is Location_ALL);

LEFT JOIN(table1)

LOAD Project,
[Mapped Project],
[Finance Code]
FROM
C:\Users\c_rsrira\Desktop\rumi_meta_mappings.xlsx
(ooxml, embedded labels, table is Project_ALL);

[deepakk · Accepted solution]

Hi,

Project field in the table and the excel file should be same. i.e the P should be capital in table.

Project and project will be considered as two different fields. hence you need to make sure its same.

[#3]

Qlikview is case-sensitive and hence ensure that the field names should be exactly same. In the above code Project and project will be treated as 2 different fields.