Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to change the value of a field on load if a value is equal to a set value:
i have tried like this
if(wildmatch([Supplier], 'TABC//212'), 'TABC') as [Supplier],
or
if(([Supplier]= 'TABC//212'), 'TABC') as [Supplier],
In these cases the change happens where this is matched 'TABC//212' and gives a '-' for all other [Supplier].
How can i leave all [Supplier] as their original value other than if the wildmatch clause or = to is met please?
Thanks
Daniel
if(([Supplier]= 'TABC//212'), 'TABC',[Supplier]) as [Supplier]
If(Condition,Then,Else)
if([Supplier]= 'TABC//212', 'TABC',
if([Supplier]='J122RTS', 'JRTS',
[Supplier])) as [Supplier]
Should work, I believe.
if(([Supplier]= 'TABC//212'), 'TABC',[Supplier]) as [Supplier]
If(Condition,Then,Else)
Ahhh,
Schoolboy error. Got it!
Thanks so much for the quick reply. Much appreciated .
Thank you
Daniel
Hi again,
If i wanted to add a second value to this, another supplier to change the name also,
how would i achieve please. I try this:
if(([Supplier] = 'TABC//212'), 'TABC') ,
if (([Supplier]= 'J122RTS'), 'JRTS',[Supplier]) as [Supplier],
But the first value (TABC//212) now does not change.
How can i add to this please?
Thanks again in advance for your help
if([Supplier]= 'TABC//212', 'TABC',
if([Supplier]='J122RTS', 'JRTS',
[Supplier])) as [Supplier]
Should work, I believe.
Thanks again,
worked a treat, some out of place brackets were throwing it out for me.
Thank you so much.
Regards
Daniel