Forum Discussion

EdjeVis's avatar
EdjeVis
New Member
2 years ago
Solved

Set value in string variable in multiple steps

Hi, Could someone please help me on this. Been searching for hours on several platforms, but can't find any solution. Challenge: I want to put a text in my column "Reason", but this text is depend...
  • BeaBF's avatar
    BeaBF
    2 years ago

    EdjeVis i'va also created  a more modular and scalable code:

     

    Reason =
    VAR DescriptionTrimmed = TRIM([Description])
    VAR DescriptionCheck = IF(LEN(DescriptionTrimmed) = 0, "Description is empty", "")

    VAR KindTrimmed = TRIM([Kind])
    VAR KindCheck = IF(LEN(KindTrimmed) = 0, "Kind is empty", "")

    VAR TypeTrimmed = TRIM([Type])
    VAR TypeCheck = IF(LEN(TypeTrimmed) = 0, "Type is empty", "")

    VAR AdditionalCheck1 = ""
    VAR AdditionalCheck2 = ""
    -- Add more check variables here as needed

    VAR Checks = {
    DescriptionCheck,
    KindCheck,
    TypeCheck,
    AdditionalCheck1,
    AdditionalCheck2
    -- Add more checks here
    }

    VAR CombinedReason =
    CONCATENATEX(
    FILTER(Checks, [Value] <> ""),
    [Value],
    UNICHAR(10)
    )

    RETURN
    TRIM(CombinedReason)

     

    BBF

BeaBF's avatar
BeaBF
Super User
2 years ago

EdjeVis i'va also created  a more modular and scalable code:

 

Reason =
VAR DescriptionTrimmed = TRIM([Description])
VAR DescriptionCheck = IF(LEN(DescriptionTrimmed) = 0, "Description is empty", "")

VAR KindTrimmed = TRIM([Kind])
VAR KindCheck = IF(LEN(KindTrimmed) = 0, "Kind is empty", "")

VAR TypeTrimmed = TRIM([Type])
VAR TypeCheck = IF(LEN(TypeTrimmed) = 0, "Type is empty", "")

VAR AdditionalCheck1 = ""
VAR AdditionalCheck2 = ""
-- Add more check variables here as needed

VAR Checks = {
DescriptionCheck,
KindCheck,
TypeCheck,
AdditionalCheck1,
AdditionalCheck2
-- Add more checks here
}

VAR CombinedReason =
CONCATENATEX(
FILTER(Checks, [Value] <> ""),
[Value],
UNICHAR(10)
)

RETURN
TRIM(CombinedReason)

 

BBF

BeaBF's avatar
BeaBF
Super User
2 years ago

EdjeVis if it's ok, please accept my answear as a solution. 

  • EdjeVis's avatar
    EdjeVis
    New Member
    2 years ago

    Hi BeaBF,

    Thanks, this is indeed more what I was looking for.

     

    Since I don't mind a bit more complicated IF-statements and I love less code and variables, I would reduce it to:

    VAR DescriptionCheck = IF(LEN(TRIM([Description])) = 0, "Description is empty", "")

    VAR KindCheck = IF(LEN(TRIM([Kind])) = 0, "Kind is empty", "")

    VAR TypeCheck = IF(LEN(TRIM([Type])) = 0, "Type is empty", "")

    VAR Checks = {
    DescriptionCheck,
    KindCheck,
    TypeCheck
    }

    VAR CombinedReason =
    CONCATENATEX(
    FILTER(Checks, [Value] <> ""),
    [Value],
    UNICHAR(10)
    )

    RETURN
    TRIM(CombinedReason)