Forum Discussion

remi's avatar
remi
Icon for Advocate II rankAdvocate II
8 years ago
Solved

copy a table and filter it

Hello all,   Is there a function that can help to copy a table and then filter based on a specific value from one column without doing it from the Edit Query side?   Thank you!
Tips and Tricks
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Yes, you go to the modeling tab and choose "New Table" and you can plug in syntax like:

     

    Table 1 = FILTER('Table',[Column] = "Value")

    You will end up with a new table of only the rows in the source table 'Table' that have "Value" in [Column]

     

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Yes, you go to the modeling tab and choose "New Table" and you can plug in syntax like:

 

Table 1 = FILTER('Table',[Column] = "Value")

You will end up with a new table of only the rows in the source table 'Table' that have "Value" in [Column]

 

 

remi's avatar
remi
Icon for Advocate II rankAdvocate II
8 years ago

Thank you Greg_Deckler , positive result!