1.yes you need to create other connection for loading excel data
2.just use the join key word between the two tables(which type of join you need left join right join or inner join or outer join)
3.can you share the date format of the field in the excel file and date format which you required in qlik.
Thanks Hemeswara Reddy.. Step 1 is fine..
I need clarification in step 2. Am loading excel in separate connection. Then I have to open a new tab in data load editor then I have to write script to join SQL & excel right.
LIB CONNECT TO '126.96.36.199';
LOAD "Emp #",
SQL SELECT "Emp #",
(ooxml, embedded labels, table is [TestEmp]);
Is it correct.
Then, Step 3, I have date format as 08/22/2017. Also checked that the number format is assigned to Date. Still when I load in to Qliksense it is coming up as Value.
Thanks for the response. Yes, I have used join statement to combine SQL & Excel file. I am ok with bringing in two datasets,. I use data manager initially & then for joining excel file. I have used data load editor to get the fields form SQL & then joined it with excel. Now struck with the date format as it is showing as date in excel & while loading on to Qliksense. It is coming up as a value.
With reference to Re: Excel import, date format wrong? . I tried the solution given by Ruben & it works fine. I'm able to load the excel file as Date format.
Format: Date("Field Name", 'YYYY-MM-DD') as "Field Name"
Eg: Date("CREATED DATE", 'YYYY-MM-DD') as "CREATED DATE"