Discussion Board for collaboration on QlikView Scripting.
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?
VBRP_RWhere MaterialNo <> '000000000000000951';Rename Table VBRP_RR to VBRP_R;
Go to Solution.
try below script and check if it gives you right result
VBRP_RWhere MaterialNo <> '000000000000000951';
drop table VBRP_R;
Rename Table VBRP_RR to VBRP_R;
Please try this
VBRP_RWhere Trim(MaterialNo) <> '000000000000000951';Rename Table VBRP_RR to VBRP_R;
Nope. Same results. The record is still in the table.
Thank you so much. I don't understand why mine would not work. The only difference is the
VBRP_RWhere MaterialNo <> 000000000000000951;drop table VBRP_R;Rename Table VBRP_RR to VBRP_R;
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
Thanks for the explaination. It makes more since now. Have a great day.