Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Mapping with wildcards

I am trying to get the script from Rob Wunderlicht working, but I get errors after:  & Concat(Key,(see added pic). What am I missing here?

1 Reply
MVP
MVP

Re: Mapping with wildcards

Are you referring to the example from the QV cookbook, available from Rob's download site?

If I remember correctly, the sample in cookbook version V10c looks a bit different, are you referrung to this version of the cookbook (http://robwunderlich.com/downloads/cookbook_v10c_PE.zip)?

From what I can see from your image (it might be helpful to post / attach the script code also to your posting, this makes it easier to copy / paste it in an editor for us), you might have an issue using a double quote instead of a single quote in line 6.

Then, your load statement is of course not complete yet, you need to define the source and you'll need to use a group by clause when using aggregation functions like concat in your load.

The script editor sometimes marks parts of the script as error (red underline), though the syntax is correct and the script works. It seems to do so in your first concat() function, claiming the concatenated delimiter string as error (I think it is correct, though).

I am not 100% sure about what this snippet should do in a more gobal context of the wildcard mapping, I assume that you will create some more code after this load to do the actual mapping, right?

Regards,

Stefan

Community Browser