Eliminating Records

[tmumaw]

Hi....I am trying to eliminate records during the load of my QVW.  However for some reason it's not working.   Does anyone see anything wrong with my logic?

Thanks

VBRP_RR:

LOAD *

Resident

VBRP_R
Where MaterialNo <> '000000000000000951'
;

Rename Table VBRP_RR to VBRP_R;

[#2]

Please try this

VBRP_RR:

LOAD *

VBRP_R
Where Trim(MaterialNo) <> '000000000000000951'
;

Rename Table VBRP_RR to VBRP_R;

Resident

[#3 · Accepted solution]

Hi ,

try below script and check if it gives you right result

Noconcatenate

VBRP_RR:

LOAD *

Resident

VBRP_R
Where MaterialNo <> '000000000000000951'
;

drop table VBRP_R;

Rename Table VBRP_RR to VBRP_R;

[tmumaw]

Nope.  Same results.  The record is still in the table.

[tmumaw]

Vikramtantry,

Thank you so much.  I don't understand why mine would not work.  The only difference is the

Noconcatenate

[er_mohit]

hii

VBRP_RR:

LOAD *

Resident

VBRP_R
Where MaterialNo <> 000000000000000951
;
drop table VBRP_R;
Rename Table VBRP_RR to VBRP_R;

[#7]

Hi,

When you are creating VBRP_RR using where clause , due to by default feature of qlikview the VBRP_RR and VBRP_R gets concatenated .

So by writing noconcatenate i make sure that two tables dont get concatenated

[tmumaw]

Thanks for the explaination.   It makes more since now.  Have a great day.