Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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;
Please try this
VBRP_RR:
LOAD *
VBRP_R
Where Trim(MaterialNo) <> '000000000000000951'
;
Rename Table VBRP_RR to VBRP_R;
Resident
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;
Nope. Same results. The record is still in the table.
Vikramtantry,
Thank you so much. I don't understand why mine would not work. The only difference is the
Noconcatenate
hii
VBRP_RR:
LOAD *
Resident
VBRP_R
Where MaterialNo <> 000000000000000951
;
drop table VBRP_R;
Rename Table VBRP_RR to VBRP_R;
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
Thanks for the explaination. It makes more since now. Have a great day.