Discussion Board for collaboration on QlikView Scripting.
Suppose I have the following:
LOAD * INLINE [
Is there a function that allows me to obtain
I have used subfield(B,';'), expanded, added a counter, reversed the order and recombined.
Is there any faster way to do this?
edit/ partially, unsolved
I hope there is no other faster way.
Is the number of values is fixed (i.e., e;d;c;b;a is 5. is it same for all?)
No the length is variable unfortunatly.
Did you check the link I have added? It seems that I can create a custom function to do so.
I am not familiar of creating a custom VBS script and then using it in the load script.
EDIT: Got it. I add it in the VBS script, run the script and then call it within the script.Quite amazing !!!! this is Gold
Still I have a complete reverse
now i need to figure out how to finetune...
This snippet worked:
r = " "
For i = 1 to ((len(t)-1)/2) step 1
r = r & mid(t,(len(t) - i*2),2)
reverse = r
It is not stable
I keep getting variable results for every reload.
I don't understand why...
has anyone experienced instability using a VB script within the load statement?