Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

selectcolumns

Hi all,

 

I am doing below select column, but i need to fetch only non blank valuesin the selectcolumn any idea on this.

 

selectcolumns(filter(table,table[column] = vaule),"pol",table[number])

 

i want table[number] to be not null

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    selectcolumns(filter(table,table[column] = value && not isblank(table[number])),"pol",table[number])