topic Re: How do I remove rows of data via the load script? in QlikView

How do I remove rows of data via the load script?

Mon, 26 Aug 2013 12:23:11 GMT

Good morning all,

How do i go about removing rows of data via the load script based upon the contents of one column?

If a particular column contains a particular value, i want to remove the entire row of data (all columns).

Any easy way to do that?

Thanks much,

Steve

Re: How do I remove rows of data via the load script?

tresB — Mon, 26 Aug 2013 12:26:50 GMT

try like:

Load A, B, C

From <Source> Where A<>'XX';

Hope this helps.

Re: How do I remove rows of data via the load script?

nilesh_gangurde — Mon, 26 Aug 2013 12:29:14 GMT

Dear Steve,

You can use the where condition same like Sql into qlikview.

then your sample code will be as follows:

Temp:

load * from Table_name.qvd where ColumnName = 'ColumnValue';

Hope this will help.

-Nilesh

Re: How do I remove rows of data via the load script?

Mon, 26 Aug 2013 12:35:54 GMT

Hi,

If you are at the script. There you say load Table files and take the file. Then you go next. There push Enable Transformation Step. So you see the columns and rows. You cna mark them say Delete Marked or go to conditional Delete. And there you can delete them by clicking. I mean you have a dropdown where you can say may "equals to" and then the name

Re: How do I remove rows of data via the load script?

rbecher — Mon, 26 Aug 2013 13:08:56 GMT

Hi Steve,

just use the KEEP statement.

. Ralf

Re: How do I remove rows of data via the load script?

jeffmartins — Mon, 26 Aug 2013 13:42:21 GMT

Hi Steve Connelly,

You could try the wildmatch() function to exclude the rows you don't want to load. The wildmatch function searches for a substring inside a string field.

The match function is similar to the wildmatch function but it performs a case sensitive comparison and the entire string should be passed instead of a substring.

See the attached file for more details. Hope this helps you.

Regards

Re: How do I remove rows of data via the load script?

Mon, 26 Aug 2013 14:56:07 GMT

Hi Steve,

I had exactly the same problem and the best solution I found was to reload data with a condition that satisfies your criteria.

My example:

Table1:

LOAD

MonthName(Monthstart(date(submitDateTime))) as MYear, *

SQL SELECT * from dbo.aaa

//(I can't use SQL "where" statement in my special case)

Table2:

NOCONCATENATE LOAD * Resident Table1 WHERE [Are_you_happy]='No';

DROP Table Table1;