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

EdjeVis's avatar
EdjeVis
New Member
2 years ago

Hi BeaBF,

Thanks for this very quick answer.

This indeed works, but now you've only checked on Description and Kind.

The trick is to check on the various combinations that are possible if you would also take Type into account.

And if I want to extend my checks, the possible combinations are increasing exponentially

  • BeaBF's avatar
    BeaBF
    Super User
    2 years ago

    EdjeVis 

    To extend the checks to include the Type column while managing multiple combinations effectively, we can use a structured approach that handles each condition based on whether each field (Description, Kind, Type) is empty or not.

     

    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 CombinedReason =
        DescriptionCheck &
        IF(DescriptionCheck <> "" && (KindCheck <> "" || TypeCheck <> ""), UNICHAR(10), "") &
        KindCheck &
        IF(KindCheck <> "" && TypeCheck <> "", UNICHAR(10), "") &
        TypeCheck

    RETURN
        TRIM(CombinedReason)
    • 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.