topic Re: remove the value not required in QlikView

remove the value not required

bsbernabe — Wed, 25 Nov 2020 16:16:04 GMT

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

Best Regards,

Bing

Re: remove the value not required

Arthur_Fong — Thu, 31 Oct 2019 03:47:33 GMT

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;

Re: remove the value not required

Surya — Thu, 31 Oct 2019 09:21:08 GMT

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);

Re: remove the value not required

bsbernabe — Sat, 02 Nov 2019 00:21:36 GMT

Thank you for your great support