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