Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Selectcolumns

I am using select columns and storing 2 columns in that selectcolumns table

then i am storing that into a variable.

how can i access onlyone column out of it.?

 

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    Anonymous Couple different ways. You could use another SELECTCOLUMNS. Also, you can use an X aggregator, MAXX, MINX, SUMX, etc.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Greg_Deckler thanks using another selectcolumn works

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    is there a way we can restrict the blank values during fectching data using selectcolumns.