topic Re: Eliminating Records in QlikView

Eliminating Records

tmumaw — Fri, 15 Feb 2013 11:32:26 GMT

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;

Re: Eliminating Records

Fri, 15 Feb 2013 11:36:56 GMT

Please try this

VBRP_RR:

LOAD *

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

Rename Table VBRP_RR to VBRP_R;

Resident

Re: Eliminating Records

Fri, 15 Feb 2013 11:44:23 GMT

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;

Re: Eliminating Records

tmumaw — Fri, 15 Feb 2013 11:45:59 GMT

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

Re: Eliminating Records

tmumaw — Fri, 15 Feb 2013 11:50:24 GMT

Vikramtantry,

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

Noconcatenate

Re: Eliminating Records

er_mohit — Fri, 15 Feb 2013 11:52:27 GMT

hii

VBRP_RR:

LOAD *

Resident

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

Re: Eliminating Records

Fri, 15 Feb 2013 11:57:52 GMT

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

Re: Eliminating Records

tmumaw — Fri, 15 Feb 2013 12:03:33 GMT

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