Skip to main content
Question

Modify attribute when data is missing


nati

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

 

 

4 replies

redgeographics
Celebrity
Forum|alt.badge.img+49

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.


nati
  • Author
  • January 30, 2023

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

 

 

 

 

 

 


redgeographics
Celebrity
Forum|alt.badge.img+49
nati wrote:

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?

 


nati
  • Author
  • January 31, 2023

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.

 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings