Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

tmumaw
Valued Contributor

Eliminating Records

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;

1 Solution

Accepted Solutions
Not applicable

Re: Eliminating Records

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;

7 Replies
Not applicable

Re: Eliminating Records

Please try this

  

VBRP_RR:

 

LOAD *

 

 

 

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

Rename Table VBRP_RR to VBRP_R;

Resident

Not applicable

Re: Eliminating Records

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
Valued Contributor

Re: Eliminating Records

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

tmumaw
Valued Contributor

Re: Eliminating Records

Vikramtantry,

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

Noconcatenate

er_mohit
Honored Contributor II

Re: Eliminating Records

hii

VBRP_RR:

LOAD *

Resident

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

Not applicable

Re: Eliminating Records

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
Valued Contributor

Re: Eliminating Records

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

Community Browser