topic Re: Change a field value outside a LOAD statement in QlikView

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

cheburashka — Wed, 06 Feb 2013 20:53:28 GMT

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

Re: Change a field value outside a LOAD statement

martin59 — Wed, 06 Feb 2013 21:44:16 GMT

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

Re: Change a field value outside a LOAD statement

martin59 — Wed, 06 Feb 2013 21:44:24 GMT

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

Re: Change a field value outside a LOAD statement

martin59 — Wed, 06 Feb 2013 21:44:36 GMT

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

Re: Change a field value outside a LOAD statement

martin59 — Wed, 06 Feb 2013 21:44:44 GMT

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

Re: Change a field value outside a LOAD statement

martin59 — Wed, 06 Feb 2013 21:44:51 GMT

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

Re: Change a field value outside a LOAD statement

cheburashka — Wed, 06 Feb 2013 22:01:22 GMT

I added My script in the question attachment.

Re: Change a field value outside a LOAD statement

Gysbert_Wassenaar — Thu, 07 Feb 2013 09:59:57 GMT

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.

Re: Change a field value outside a LOAD statement

cheburashka — Thu, 07 Feb 2013 10:14:43 GMT

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?

Re: Change a field value outside a LOAD statement

cheburashka — Thu, 07 Feb 2013 12:12:49 GMT

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

-Koen

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

Thu, 14 Feb 2013 13:52:00 GMT

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