# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for
Did you mean:
Contributor III

## Field Lookup Logic

Hi Community,

I got stuck at one point. I've tried number of logic's but didn't succeed.

Here is my requirement:

This is the Data:

LOAD * INLINE [
String, Number
Gordon/JayHanbey, 1/2
JimScott/Hardy, 2/1
Gemma, 1
JohnSmith, 2
Ryan/AlexWhite/SeanWilliams, 1/2/3
];

Regards,

Nol

Labels (1)
• ### QlikView

1 Solution

Accepted Solutions
Master

One Solution is:

``````tab1:
LOAD *, SubField(String&'/','/',IterNo()) As Str,
SubField(Number&'/','/',IterNo()) As Num, SubStringCount(String,'/') As Cnt
While IterNo()<=SubStringCount(String&'/','/')
;
LOAD * INLINE [
String, Number
Gordon/JayHanbey, 1/2
JimScott/Hardy, 2/1
Gemma, 1
JohnSmith, 2
Ryan/AlexWhite/SeanWilliams, 1/2/3
];``````

3 Replies
Master

One Solution is:

``````tab1:
LOAD *, SubField(String&'/','/',IterNo()) As Str,
SubField(Number&'/','/',IterNo()) As Num, SubStringCount(String,'/') As Cnt
While IterNo()<=SubStringCount(String&'/','/')
;
LOAD * INLINE [
String, Number
Gordon/JayHanbey, 1/2
JimScott/Hardy, 2/1
Gemma, 1
JohnSmith, 2
Ryan/AlexWhite/SeanWilliams, 1/2/3
];``````

Contributor III
Author

Hi Saran,

This is what I need. Wow, what an amazing solution.

Short, sweet & perfect.

Thanks for putting your time & efforts into my issue.

Many Thanks.

Regards,

Nol

Master

you welcome