Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a certain amount of information associated to OrderID's - which are all numeric. However, we have test orders in the system (a lot of them) that all start with 'F'.
I want to try and eliminate these dummy orders and their associated information - but I'm not sure how to write that into the script. in SQL, I use the like function with a wildcard - but it looks like the wildmatch function in Qlikview doesn't duplicate this exactly.
Any suggestions?
Example:
DUMMY DATA REAL ORDERID
F653519 1089136
I re-tried this after we fixed some seemingly unrelated issues and this did the trick, thank you!