Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

remove the value not required

Hello There,

This is my sample data my concern is to remove if all the value of Serial No. is =0 or 1 or - or null and how can i do this in load script ?

Agreement IDCustomer NameSerial NoTrans_Date
135844ROMEO TORRES2DY101123403/06/2015
137706BOYET BAYG123-20636603/24/2015
220859JUN FOX107/31/2016
291720RAM106/30/2017
155886WAREHOUSE008/08/2015
155864DEPO -10/08/2015

 

Best Regards,

Bing

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Try this:

Raw:
load * inline [
Agreement ID,Customer Name,Serial No,Trans_Date
135844,ROMEO TORRES,2DY1011234,03/06/2015
137706,BOYET BAY,G123-206366,03/24/2015
220859,JUN FOX,1,07/31/2016
291720,RAM,1,06/30/2017
155886,WAREHOUSE,0,08/08/2015
155864,DEPO,-,10/08/2015
];
NoConcatenate
tempRaw:
load * resident Raw
where len([Serial No])>1;
DROP Table Raw;

Rename table tempRaw to Raw;

View solution in original post

3 Replies
Highlighted
Partner
Partner

Try this:

Raw:
load * inline [
Agreement ID,Customer Name,Serial No,Trans_Date
135844,ROMEO TORRES,2DY1011234,03/06/2015
137706,BOYET BAY,G123-206366,03/24/2015
220859,JUN FOX,1,07/31/2016
291720,RAM,1,06/30/2017
155886,WAREHOUSE,0,08/08/2015
155864,DEPO,-,10/08/2015
];
NoConcatenate
tempRaw:
load * resident Raw
where len([Serial No])>1;
DROP Table Raw;

Rename table tempRaw to Raw;

View solution in original post

Highlighted
Creator II
Creator II

Hello.,

Directly doing in Front end in dimentsion 

if(len([serial no] > 1) ,[Serial No],Isnull())

Try this in Front end

 

In Backend

 

before semi column

where len([serial no] >1);

Highlighted
Creator
Creator

Thank you for your great support