topic Hyper Interesting case !!! Need professional help in QlikView

Hyper Interesting case !!! Need professional help

ivan_will — Thu, 14 Apr 2011 22:03:00 GMT

Hi all,

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/1122.QVapp.rar:550:0]

In the pic below I'm showing whats the case:

I'm trying to catch some strings from the field images and put them cleared in another table, but the script I'm using don't do that correctly but seem to working to the 6th line fine!

In the attached app you can see it.

I've trying to fix the bug in the app but without any success ... please help!

Thanks in advance!

Hyper Interesting case !!! Need professional help

Oleg_Troyansky — Thu, 14 Apr 2011 22:34:10 GMT

Ivan,

it took me a few minutes to find the catch... You are using function fieldvalue(), which is giving you an X-th element from the list of field values. So, you expected to see the first line under number 1, the 7th line under number 7 and the 11th line under number 11... Well, the catch is that the List with field values only stores distinct values, so your line # 11 contains 7th distinct value of the field imagess - that's why the images from line 11 got registered under number 7...

In order to get correct values, replace FieldValue() with function Peek(), where you can specify the table name and the row number in the table, to get the accurate value without any de-duplication problems.

cheers,

Hyper Interesting case !!! Need professional help

ivan_will — Thu, 14 Apr 2011 22:44:19 GMT

Use that function let vImages = text(peek('imagess',$(h)-1,main2)); but it gives only the first line info !

Hyper Interesting case !!! Need professional help

ivan_will — Fri, 15 Apr 2011 05:39:00 GMT

Any ideas ?

Hyper Interesting case !!! Need professional help

Miguel_Angel_Baeyens — Fri, 15 Apr 2011 06:35:19 GMT

I've changed a bit your script

for h=1 to NoOfRows('main2') data2.1:LOAD Distinct $(h) as ID, substringcount(imagess, '.jpg') as JPGInstances, RecNo() as images_recNo, SubField(textbetween(imagess, '/Autotest/', '.jpg'), '=') as final_imagesRESIDENT main2 WHERE ID = $(h); next

Obviously this needs some tuning, but the idea is that the SubField() function, unless a count number is specified, will create as many records as separators it will find in the string:

Example:LOAD SubField(Field, '=') AS Field INLINE [FieldA=B=CD=E=FG=H=I];

But I'm afraid I'm unable to get how you want to split your code exactly.

Hope that helps.

Hyper Interesting case !!! Need professional help

ivan_will — Fri, 15 Apr 2011 07:34:25 GMT

Hi ,

want to have this as result :

so one ID have no, one or more jpg. in the original text and want to have it all.

🙂

Hyper Interesting case !!! Need professional help

ivan_will — Fri, 15 Apr 2011 07:45:14 GMT

Ahmm ... , another ideas how to do that work ?

Hyper Interesting case !!! Need professional help

ivan_will — Fri, 15 Apr 2011 08:09:10 GMT

Hyper Interesting case !!! Need professional help

Miguel_Angel_Baeyens — Fri, 15 Apr 2011 08:58:06 GMT

Hi,

As I mentioned above, the code above works with a small tuning:

for h=1 to NoOfRows('main2') data2.1:LOAD $(h) as ID, substringcount(imagess, '.jpg') as JPGInstances, RecNo() as images_recNo, TextBetween(SubField(imagess, 'alt='), '/Autotest/', '.jpg') as final_imagesRESIDENT main2 WHERE ID = $(h); next

Please take into account that the people that participate in the QlikCommunity don't have your data model, nor we work for QlikView, so some ideas will need refination from your end.

Hope that helps.

Hyper Interesting case !!! Need professional help

ivan_will — Fri, 15 Apr 2011 09:10:30 GMT

Ooo, that's great ! Thanks! It works !!! 🙂

Thanks again for the help!