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;
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.
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;
Thank you so much. I don't understand why mine would not work. The only difference is the
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.
VBRP_RWhere MaterialNo <> 000000000000000951;drop table VBRP_R;Rename Table VBRP_RR to VBRP_R;
Retrieving data ...