Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
Showing results for 
Search instead for 
Did you mean: 
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

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?