Hi all,
Can anybody help @Shevy with their situation?Thanks!
Hello @Shevy, This would be a great thing to ask the DOMO Support Team. You can reach them at the following url https://support.domo.com/
Hello @Shevy,As a reminder, I contacted you via email asking for a link to your dataflow so that I may help troubleshoot this issue for you.When you're ready to proceed, please reply to my email, and I can help you then.Thank you!
Steve Cook
Domo Support
I am having a similar issue. I want to filter rows *only* when their value is specific (Labor). I have used "Labor", 'Labor', and Labor and each itteration nets 0 records. Please advise.
Anyone have an answer for this?
@Asydnor Have you reported these behaviors in tickets to Domo Support? I would very much like to have examples of these issues you see brought to our attention.
If you have open tickets, please reference them here for me. You should have been provided a CASE ID for each ticket opened.
If you do not have open tickets, please do open some via the Support portal here: support.domo.com
If at all possible, please provide examples for us of where you see this.
Thank you!
Hi All,
I am having the same issue. When applying multiple filters for a TEXT field, it doesn't seem to work. If I have one rule, it works fine, but after adding multiple, it doesn't work at all. Thanks!
I personally never use the equals but always contains and does not contains. Have you tried going to the dataset and copying the text and then pasting that in the filter field? Sometimes there are whitespaces there and just typing them in does not catch them. Also, make sure your column is actually a text field by setting the column type. I have never had any issues with filtering text fields so if it persists I would definitely put in a ticket.
Experiencing the same issue. When applying multiple filters in Magic ETL, it returns 0 results. Even though I see the raw data and it's clearly there, however, can't use filters to get the sample of the data.
Hello @user095063,
I work in Domo Support, and can provide some help here.
Very often, with this type of issue, it'll turn out that something weird is happening with whitespace. Examples I run into a lot are:
I advise you review your data to see if any of these issues exist, along with simple spelling errors in the data that aren't in your filter value.
If you can't find the cause of the problem, please go to support.domo.com and submit a support ticket. Please indicate the dataflow you're working with, which filter tile/s you're looking at, and which value/s in your data you expect to make it through the filter tile that are not making it through.
Solved (for me):
Filtering using 'does not contain' on a simple text string. I got it to work for a single filter on my first try, but as I tried to add other filters it stopped working. The Run Preview process just refused to do anything once it got to the Filter Row step.
Then I stumbled upon what I think was the problem for me, and probably others. After you type in your rule, there is a big button labeled "Add Filter Rule". I should be forgiven for thinking that is what you are supposed to hit to complete the process of adding the rule just above. But what it seems to do is actually open up a new rule dialogue box, and if that dialogue box remains open, the process fails. Once I closed that empty dialogue box by hitting the large "X" to the right, everything processed fine.I have replicated this problem, and added several more rules and it all works great.