excel loading

Anonymous — Sat, 15 Jan 2011 01:18:42 GMT

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);

excel loading

deepakk — Sat, 15 Jan 2011 04:19:14 GMT

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.

excel loading

Sat, 15 Jan 2011 07:39:46 GMT

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.

topic excel loading in QlikView

excel loading

excel loading

excel loading