Discussion Board for collaboration related to QlikView App Development.
I got stuck at one point. I've tried number of logic's but didn't succeed.
@sunny_talwar @swuehl @kaushiknsolanki
Here is my requirement:
This is the Data:
LOAD * INLINE [String, NumberGordon/JayHanbey, 1/2JimScott/Hardy, 2/1Gemma, 1JohnSmith, 2Ryan/AlexWhite/SeanWilliams, 1/2/3];
One Solution is:
LOAD *, SubField(String&'/','/',IterNo()) As Str,
SubField(Number&'/','/',IterNo()) As Num, SubStringCount(String,'/') As Cnt
LOAD * INLINE [
View solution in original post
This is what I need. Wow, what an amazing solution.
Short, sweet & perfect.
Thanks for putting your time & efforts into my issue.