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

BA_Pete's avatar
BA_Pete
Super User
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