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
Okay here goes.
LOAD
ORDER_NO&'_'&SITE as ORDER_KEY;
LOAD
Text(ORDER_NO) as ORDER_NO,
SITE
FROM database_table.qvd (qvd)
Script:
LOAD Text(test) As test Inline
[
test
123
123.
0123
];
Output in list box with frequencies:
Hi Andrew,
the example attached is as per Stigchel reply, just loading from a simple csv you end up with both 123 and 123.
What are you loading from, can you supply the SELECT part of the script? Is the . getting stripped out before it gets into QV?
Regards
Andy
I expect the problem already exists in the qvd. The Text() needs to be in the original load from the database (in the qvd generator).
HTH
Jonathan
Tell me, do you bleed? You will!
Hi,
I'm loading straight from the database. It is Oracle, would that make a difference? This then gets put into the .qvd file.
Kind Regards
Andrew
"That's how it starts. The feeling, the powerlessness… that turns good men cruel"
Hi Andrew,
unfortunately I have no oracle knowledge at all, but if you execute the select statement in Oracle, does it actaull return the 123. ?