Hi !
What I have is two colums and sometimes, I have to modify column1, but not each row.
For examples :
But I don't know how...
I hope it's clear enough.
Thanks for your help.
Nati
+25
Generally speaking, you can use a conditional value in an AttributeManager to achieve this, although to be honest I'm not entirely sure I understand your logic.
If you can capture the criteria in a Tester you can use the same settings in the conditional value.
Hi !
Could you tell me more ?
"My" logic (which is not mine actually) is a little complicated.
IF PR1+0 can be found in created column3 ==> PR1 in column1
IF PR1+0 cannot be found, it means that PR1 does not exists ==> so, I have to get PR1+ [number that comes first] ; PR1+120 (for example)
Is it clearer ? :-/ I'm not sure...
+25
Hi !
Could you tell me more ?
"My" logic (which is not mine actually) is a little complicated.
IF PR1+0 can be found in created column3 ==> PR1 in column1
IF PR1+0 cannot be found, it means that PR1 does not exists ==> so, I have to get PR1+ [number that comes first] ; PR1+120 (for example)
Is it clearer ? :-/ I'm not sure...
No, it's not clear at all.
You have columns 1 and 2, right? So
"Column1 : PR1 Column2 : 0 ==> PR1+0 exists and PR1 stays as it is."
You mean:
IF Column1 = PR1 AND Column2 = 0 PR1 is unchanged
Am I correct?
yes...
IF Column1 = PR1 AND Column2 = 0 THEN Column1 is unchanged
IF Column1 = PR2 AND Column2 <> 0 THEN Column1 is changed
=> Column1 = "Column1+column2"
BUT maybe, I found another way... !!
I concatened LIBELLE and ABSD and a "+" in between.
Now I have to say : IF LIBELLE_AB CONTAIN "+0" THEN REPLACE BY "PRxx"
I just have to keep LIBELLE alone !
How could I do that ? 🙂
...................................................................................
Later...
I found my way !!
@ReplaceString(@Value(LIBELLE_ABSD),"+0","",caseSensitive=FALSE)
Thanks for helping.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
