Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
Solved

Custom Column

Hello everyone!   I got stuck with a data set I'm working right now, and i will appreciate any help I can get.    In my first column i have different ID numbers. The ID number appears first, and ...
  • BA_Pete's avatar
    BA_Pete
    2 years ago

    Hi,

     

    You can add a new custom column like this:

    if Text.Contains([Entity], "-") then [Entity] else null

     

    Then select your new column and go to the Transform tab > Fill (dropdown) > Down.

    Then filter your [Entity] column on Does Not Contain "-".

     

    Pete

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Thank you a lot, it was way easier than what I was trying! I really appreciate it

  • BA_Pete's avatar
    BA_Pete
    Super User
    2 years ago

     

    No problem, happy to help.

    Feel free to give a thumbs-up and accept the answer as the solution 👍

     

    Pete