Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I currently have two different orders and for this instance we will call it Order 123 and there is another order in the system with Order No 123. (with a full stop at the end). However, when I look in QlikView it is showing that there are two orders for 123 when in fact there aren't due to the full stop. Is there a way of getting around this?
Thanks in advance.
Andrew
Remove the dot while loading Order No in script like below
Load Purgechar(OrderNoField,'.') As OrderNoField ...
If these two records belong to the same order, I would recommend removing the full stop on load time:
LOAD
purgechar(OrderField,'.') as OrderField,
...
while loading you can change the Order nos like
=PurgeChar('Order123.','.')
This will return Order123, the trailing fullstop is removed.
Hi,
Try
Text(Replace(OrderNumber, '.', ''))
Hope this helps you.
Regards,
Jagan.
Hi,
Can you explain your requirement with examples.???
When you need two different orders and when you required as one.
Regards
Hello.
QlikView currently shows Order 123 with a frequency of two.
However, when I look in the database there is Order 123 (which QlikView shows) and Order 123. (which QlikView doesn't show because of the full stop.)
What I require is the two to be shown differently, ideally as they are in the database.
Kind Regards
Andrew
Piet's suggestion is correct and it should work. I suggest that you post the relevant part of your load script to see why it appears not to be working for you.
Jonathan