Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to filter a table?

Hello   The table I download from the source has some rows that I want to delete them. To identify these rows, I will need to use criteria like [Column1]=*something_not_case_sensitive1* OR [Column...
Need Help
v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi Anonymous ,

 

In Query editor, you may add a custom column to distinguish rows that you need to filter out.  Then you can remove the "null" value rows via choosing the option "Remove Empty".

 

For example :

 

if [Date]="28-2-2019" and [Workitemid]=1 then null else 1

 

 

 

 

Best Regards,

Amy

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.