Skip to main content

Hi !

 

What I have is two colums and sometimes, I have to modify column1, but not each row.

 

For examples :

  • Column1 : PR1 Column2 : 0 ==> PR1+0 exists and PR1 stays as it is.
  • Column1 : PR1 Column2 : 120
  • Column1 : PR1 Column2 : 500
  • Column1 : PR12 Column2 : 120
    • ==> there is no column2 = 0
    • ==> this means that PR12 doesn't exist,
    • ==> so I need to get this another value in column1 : 'PR12+120'

But I don't know how...

I hope it's clear enough.

Thanks for your help.

 

Nati

 

 

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...

 

 

 

 

 

 


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... !!

imageI 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.

 

 


Reply