Loading descriptions in different formats into labels

[#1]

Dear all,

I have tried Mapping with wildcards from the QV Cookbook (http://robwunderlich.com/downloads/)  example "Mapping with a table using wildcards" .

This works perfect for a few lines, but If I want to use it for more than approx 10 statements than it's not working anymore.

It's for using in a qwv for bankstatements. The used discription is always mixed in length, place of the needed part and use of numbers and letters. Eg

Descriptions:

1256 SUPER 56    

1 NEXT FIRM 55663

PLACE 69.12.63

I want to have then:

Descriptions:                   Key:                    Label1               Label2          Label3

1256 SUPER 56               *SUPER*             FOOD               BREAD          CompanyA

1299 SUPER 56               *SUPER*             FOOD                     BREAD     Company A

1 NEXT FIRM 55663          *FIRM*               FOOD                  MEAT          CompanyB

PLACE 69.12.63               *69.12*               BANK               BANK               CompanyC

Etc etc for many (approx 100) descriptions.

Then in the dashboard I want to see eg all "BREAD" or "Company A".

Anyone have a solution? Maybe a loop?

[Vegar]

Does qlikview components have the same limitations as the QV cookbook?

If you don't know I'll suggest you give it a try.

You'll find it here: http://qlikviewcomponents.org/

Best regards

Vegar Lie Arntsen

QlikView consultant at egbs consulting ab http://egbs.se

Blog (in Swedish): http://bi-effekten.se

[#3]

I do not really understand your reply, the qlikview components are examples, right? I do not really know where to look for the thing I need.

In excel it is not really feasible, in Acces it can be done, so I guess in QV it should be extremely difficult, but apparently it is...

Anyone an idea?

[Vegar]

No, QVC is not just a bunch of examples. It is a open source script-library initiated and maintained by Rob Wunderlich.

I find it usefull to use for example when doing just wildmatches and when importing variables from a flat file.

Take a look at my attached example.

To run the script yourself you need to download QlikView Components and adjust the include search path.

NB: I have not checked if it will run smoothly on 100+ descriptions.

Best regards

Vegar Lie Arntsen

QlikView consultant at egbs consulting ab

Blog (in Swedish): bi-effekten.se