Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I've started working with Qlikview about two weeks ago so I'm really sorry about the silly question i'll present here. Please forgive me for my ignorance..
I have a code that looks like on my database:
1. 949848_9898989_3727
2. 9483_87_97987987987
0_98983_879898_2222
I want to seprate the code and have the value of the first number until the "_"
example:
in the first code the value is : "949848"
in the second : "9483"
in the last code : "0"
in Excel it's the "Text To Column" action that can help...but i want to know how to do it on Qlikview...
Can anybody help?
Thanks in advance,
In your above sample, are '1.' and '2.' part of your data or just indicating record numbers?
If latter, I think you could use subfield() function in your load to get the first part of each record:
LOAD
...
subfield(YOURFIELD,'_',1) as CodeValue,
...
from DBTable;
Hope this helps,
Stefan