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

[#1]

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

[tresesco]

try like:

Load A, B, C

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

Hope this helps.

[nilesh_gangurde]

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

[#4]

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

[rbecher]

Hi Steve,

just use the KEEP statement.

. Ralf

[jeffmartins]

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

[#7]

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;