Forum Discussion

RamaKrishna8989's avatar
RamaKrishna8989
Helper I
3 years ago
Solved

Is it possible to enter Boolean values in Text data type column? If yes, How?

Hi,

 

When i enter as TRUE/FALSE or True/False in Text data type column it is considered as String which is leading to incorrect output. Is it possible to enter Boolean values in Text data type column? If yes, How?

 

systemadmindemo 

amitchandak 

Greg_Deckler 

Need Help
  • TheoC's avatar
    TheoC
    3 years ago

    RamaKrishna8989 This is merely showing you what the results are for each individual event if it were its own column.  It's not saying that the outcome of mixed formatted records in a column would automatically calculate the specific output as it is listed in that table. Below is an example of what I mean:

     

    1. The column True/False is boolean structured. Therefore TRUE = 1 and FALSE = 0.

    2. The column 1/0 has a blank, a zero and ones.  The output is the Measure 1/0s which aligns to the AVERAGEA output.  

     

     

    Hope this makes sense.

     

    Theo 🙂

     

10 Replies

  • TheoC's avatar
    TheoC
    Community Champion
    3 years ago

    Hi RamaKrishna8989 yes, this can certainly be done.  Just add " " at the start and end of the condition to determine whether the condition you're putting forward is TRUE/FALSE.

     

    If I've misunderstood your question, please feel free to add an example of what you're referring to.

     

    Thanks,
    Theo

     

     

    • RamaKrishna8989's avatar
      RamaKrishna8989
      Helper I
      3 years ago

      TheoC 

       

      Here, TRUE and FALSE are considered as Text, i want them to be considered as Boolean so my calculation happens correctly.

       

       

      • TheoC's avatar
        TheoC
        Community Champion
        3 years ago

        RamaKrishna8989 If your source data contains Col 1 and the source data has 1, FALSE, One, TRUE, then you will need to modify the data in Col 1 in the raw source file.

         

        The boolean output should be based on a condition being met or not being met.  For example:

         

         

        I hope this makes sense?

         

        Thanks heaps

        Theo