Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Kohli
Creator II
Creator II

Remove the undated records from the Table..

I have Table Sales. Like 

Date, Name, Sales

10/01/2017, Rahul, 1500

12/01/2017, manoj, 1200

13/01/2018, Krish, 1300

                       naresh, 1200

 

I want remove the naresh record from table 

 

Labels (1)
1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

Load 
Date,
Name,
Sales
From [YourTable] where Name <>'naresh';

or 

Load 
Date,
Name,
Sales
From [YourTable] where Date<>null();

 

View solution in original post

2 Replies
Frank_Hartmann
Master II
Master II

Load 
Date,
Name,
Sales
From [YourTable] where Name <>'naresh';

or 

Load 
Date,
Name,
Sales
From [YourTable] where Date<>null();

 

sasis551
Contributor III
Contributor III

Hi, try this

 

Load 

Date,

Name,

Sales

from loaction where date<>'';