remove rows

[Anonymous]

Hi,

I loaded query from SQL, where I got many rows for each respondentID.

Then I want to remove rows, which has Adoption.

I tried to load from resident table with condition where Dimension<>'Adoption'. Didn't work.

How to remove them?

Regards,

[veidlburkhard]

Hi Vladimir,

can you give a screen shot of your script where you tried this load?

Then I will have a look...

Regards

Burkhard

[#3 · Accepted solution]

• Field names and values are case sensitive so make sure they match and also check the spelling
• Do a preload like below

Load

*

Where Dimension <> 'Adoption' ;

SQL Select *

From DataBase;

[stevedark]

Hi Ajay,

In your code would this not bring all the rows across from SQL regardless of the Dimension, and then subsequently drop them out of memory.  This be a waste of bandwidth and not make use of any SQL indexing.  Surely this would be more efficient:

Load

*

;

SQL Select *

From DataBase

Where Dimension <> 'Adoption'

;

[#5]

Yup. Absolutely true