Forum Discussion
Filter not working in Query editor, any help
Hi Experts
Objective is to filter one of the coloumns by specific string and rest of the modeling is based on the associated data.
In the data model, for that specific column, I am happily able to filter the string, but when click on transform data, where I can actually put some code to ensure real time report, when I click on filter, I do not see my specific data, what could be the issue
As part of trouble shooting:
I deleted the data and loaded it again
My data source is right and yes every time I can see my relevant data in the drop down filter but I cannot when I look for same in the transform data (Query Editor). Please advise.
8 Replies
Hi acerNZ ,
Does your data contains more than 1000 rows?
If yes, then you can filter that using Advanced Editor.
Did I answer your question? Mark my post as a solution!
Anonymous Thank you for response, Yes they are more 10,000 rows and Please can you point me to links or way to filter the row for a particular test? can I put in SQL commands in advanced editor?
Are we talking about the dropdown that appears when you click on the caret in the column header?
Does it say 'List may be incomplete'----- Load More ?
