Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cheburashka
Creator III
Creator III

Create a new field with the field values based upon the string search in another field.

Hello,

I would like to change the field value of the field 'Classificatie' if another field ' [Naam v/d tegenpartij :] ' contains a specific string.

How to check if the field ' [Naam v/d tegenpartij :] '  contains 'DATS' or 'totop' ? I tried the following code:

If( WildMatch([Naam v/d tegenpartij :], '*DATS*', '*totop*' ) , 'Tanken', 'Geen' );

But there is a red line under the comma before Tanken. So what is wrong?

How to change the field value of 'Classificatie' of the table [Transacties] based on the above if function?.

,Thx for your help.

Message was edited by: Koen Bal

1 Solution

Accepted Solutions
Not applicable

Hi Koen,

This can be solved by modifying the mappingwithwildcards.qvw.

Which can be found in Rob Wunderlichs Cookbook (http://robwunderlich.com/downloads/).

 

kind regards,

Dion

View solution in original post

10 Replies
martin59
Specialist II
Specialist II

Hi,

I'm not sure to understand as well. Could you send us your entire script ?

But you can't do that if you're not in a Load statement.

Hope that helps you,

Martin Favier

martin59
Specialist II
Specialist II

Hi,

I'm not sure to understand as well. Could you send us your entire script ?

But you can't do that if you're not in a Load statement.

Hope that helps you,

Martin Favier

martin59
Specialist II
Specialist II

Hi,

I'm not sure to understand as well. Could you send us your entire script ?

But you can't do that if you're not in a Load statement.

Hope that helps you,

Martin Favier

martin59
Specialist II
Specialist II

Hi,

I'm not sure to understand as well. Could you send us your entire script ?

But you can't do that if you're not in a Load statement.

Hope that helps you,

Martin Favier

martin59
Specialist II
Specialist II

Hi,

I'm not sure to understand as well. Could you send us your entire script ?

But you can't do that if you're not in a Load statement.

Hope that helps you,

Martin Favier

cheburashka
Creator III
Creator III
Author

I added My script in the question attachment.

Gysbert_Wassenaar

Since you're using the qvc library, have a look at the CreateWildmapExpression.qvw example. That's what you're going to need. And you'll have to do it in a load statement. You can't use 'loose' statements in your script to change data in a table.


talk is cheap, supply exceeds demand
cheburashka
Creator III
Creator III
Author

Hello,

Thx I'll check the CreateWildmapExpression.qvw .

So can I reload a table I've loaded earlier in the script and then start changing values of the 'classificatie field' based upon the values of the field '[Naam v/d tegenpartij :]' ?

Or how should I do it?

cheburashka
Creator III
Creator III
Author

Can you please remove your multiple copies of yout answer. thx

-Koen