Forum Discussion

chq's avatar
chq
Icon for Helper II rankHelper II
6 years ago
Solved

Grouping by Column Contains?

My data looks somethng like this... Transaction # Type Code Type (Desired Column) 12 1000 Long Long Term 12 101 Theatre Long Term 12 1900 Baseball Long Term 99 104 T...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

chq , create a new column like

New column =
var _1 = countX(filter(table,[Transaction #]=earlier([Transaction #]) && [Type]="Type"),[Transaction #])
return
if(isblank(_1) || _1 =0,[Type],"Long Term")

  • chq's avatar
    chq
    Icon for Helper II rankHelper II
    6 years ago

    @amitchandak  Would this be able to apply to multiple types, for example if it doesn't contain Long or Baseball but does contain Theatre then it equals Theatre?

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    I have Taken count of long , you have one more countx and create logic

    or use in

    [Type]="Long"

    [Type]="Basketball"

     

    or

    [Type] in{"Long","Basketball"}