Data loading not properly from Notepad

[Kohli]

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.   

[kkkumar82]

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.

[YoussefBelloum]

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...

[Kohli]

Iam loading into qliksense.