Field Lookup Logic

[RD_Nol]

Hi Community,

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, Number
Gordon/JayHanbey, 1/2
JimScott/Hardy, 2/1
Gemma, 1
JohnSmith, 2
Ryan/AlexWhite/SeanWilliams, 1/2/3
];

Regards,

Nol

[Saravanan_Desingh · Accepted solution]

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
];

[RD_Nol]

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

[Saravanan_Desingh]

you welcome