Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create new column with specific data from a different column

Hi everyone   I have a a table where i need a new column made based on info on one of the other columns.   The table looks like this  Order No. Type Description 1 A (blank) 1 B (b...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try new column

    New column =
    var _ord = [Order No]
    var _type = "C"
    return
    if(isblank([Description]), maxx(filter(Table, [Order No] =_ord && [Type] ="C"),[Description]) ,[Description])

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try new column

New column =
var _ord = [Order No]
var _type = "C"
return
if(isblank([Description]), maxx(filter(Table, [Order No] =_ord && [Type] ="C"),[Description]) ,[Description])

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you for the swift answer amitchandak 

 

There was a little misunderstanding in how i wanted the column. Your calculation first checked for a description and then found the one with type "C" if the current Description was blank. I needed all to be from their respective type "C", so i altered your calculation and removed the IF sentence along with isblank.

Like this:

New column =
var _ord = [Order No]
var _type = "C"
return
maxx(filter(Table, [Order No] = _ord && [Type] = _type),[Description])

That did the trick and now it works like a charm. Thank you for the help.