Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Kohli
Contributor

Data loading not properly from Notepad

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.   

3 Replies
kkkumar82
Valued Contributor III

Re: Data loading not properly from Notepad

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
Esteemed Contributor

Re: Data loading not properly from Notepad

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
Contributor

Re: Data loading not properly from Notepad

Iam loading into qliksense.

Community Browser