Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
data in Note pad like therse..
LineNO EmployeeID StartDate EndDate BaseSalary
1 1.00 1/1/2008 00:00:00 31/12/2008 00:00:00 100000
2 1.00 1/1/2009 00:00:00 31/12/2009 00:00:00 110000
3 1.00 1/1/2010 00:00:00 31/12/2010 00:00:00 120000
4 1.00 1/1/2011 00:00:00 31/12/2011 00:00:00 130000
5 1.00 1/1/2012 00:00:00 31/12/2012 00:00:00 140000
6 1.00 1/1/2013 00:00:00 31/12/2013 00:00:00 150000
7 1.00 1/1/2014 00:00:00 160000
8 2.00 1/4/2010 00:00:00 31/12/2010 00:00:00 35000
9 2.00 1/1/2011 00:00:00 31/12/2011 00:00:00 36050
10 2.00 1/1/2012 00:00:00 31/12/2012 00:00:00 37132
at the time of loading , Iam getting like these..
LineNO EmployeeID StartDate EndDate BaseSalary
1 1.00 1/1/2008 00:00:00 31/12/2008
2 1.00 1/1/2009 00:00:00 31/12/2009
3 1.00 1/1/2010 00:00:00 31/12/2010
4 1.00 1/1/2011 00:00:00 31/12/2011
5 1.00 1/1/2012 00:00:00 31/12/2012
6 1.00 1/1/2013 00:00:00 31/12/2013
7 1.00 1/1/2014 00:00:00 160000
8 2.00 1/4/2010 00:00:00 31/12/2010
9 2.00 1/1/2011 00:00:00 31/12/2011
10 2.00 1/1/2012 00:00:00 31/12/2012
How could i solve these.
I feel the problem is with the delimiter, what is the delimiter you have selected when you selected the file
first of all where you tried this loading in QlikView or Qlik Sense?
If possible could you attach a sample of 10 rows from your data as a text file.
Hi,
it is splitting the StartDate column in 3 parts
try loading like this:
TABLE:
LOAD
LineNO,
EmployeeID,
Timestamp#(StartDate,'DD/MM/YYYY hh:mm:ss') as StartDate,
Timestamp#(EndDate,'DD/MM/YYYY hh:mm:ss') as EndDate,
BaseSalary
FROM...
Iam loading into qliksense.