Skip to content

    • Magic ETL

    Magic ETL

    Counting characters in ETL?

    Member
    in Magic ETL

    Hi there,

     

    I know there's a way in Python to count characters similar to LEN() in Excel, but I don't know Python at all to be able to use it as a tile in the ETL.  

    Can someone help me figure out how to add a new column of character count to a dataset using Python?

     

    Thanks!

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Comments

    • Coach

      Does it need to be done in Python?

       

      You can do this with a simple LENGTH function call either in SQL or via a Beast Mode:

       

      1. LENGTH(`Column Name`)
      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

      I'd prefer to use Python so I can keep it all part of one ETL flow rather than chunk it out into another dataset in MySQL, and a Beastmode won't work because I need to aggregate up within the ETL.

    • Domo Employee

      Python has a len() function...

       

      you would just define your new field... something like this

      1. length = len(string_field)
    • Member

      Thanks!

      I knew that it had that function, but I wasn't sure how to write the code so that it'd put out a new column containing the length.  So there's no print function?  Just "length = " ?

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories