topic Field Lookup Logic in QlikView

Field Lookup Logic

RD_Nol — Sat, 16 Nov 2024 00:48:26 GMT

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

Re: Field Lookup Logic

Saravanan_Desingh — Tue, 21 Apr 2020 14:45:49 GMT

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

Re: Field Lookup Logic

RD_Nol — Thu, 30 Apr 2020 20:06:55 GMT

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

Re: Field Lookup Logic

Saravanan_Desingh — Thu, 30 Apr 2020 20:57:15 GMT

you welcome