This content has been marked as final. Show 3 replies
I am just starting the qlikview connection with a MySql DataBase and I've encountered my first problem which is giving me a hard time.
This is my problem:
I have this sequence of numbers:
but I just need the first 8 numbers.
As a qlikview script I used the following sentence:
If(Len(number)=9,Left(number,8) as Number
but with the MySql script I can't find a similar function.
Can anybody help me?