community
cancel
Showing results for 
Search instead for 
Did you mean: 
With our short, effective, relevant, and interactive lessons that include videos, activities, and quizzes, you'll be up and running in no time!
Interactive Lessons
With our short, effective, relevant, and interactive lessons that include videos, activities, and quizzes, you'll be up and running in no time!
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Filtering Data

Sr. Learning Strategy Manager
Sr. Learning Strategy Manager

 

Lesson Objective: Learn to quickly filter your data to isolate rows that fit your criteria. remove the data that you don't want or split it into its own isolated stream.

Estimated Time: ~7 Minutes

Description:  

  • Learn the benefits of removing unneeded rows
  • Discover the Filter tool and its behavior
  • Understand the difference between basic and custom filters
  • Build your first basic filter 
  • Learn how to combine expressions as a custom filter
  • Test your knowledge with a quiz

Recommended Follow-Up Training:  Understanding Data Types

Software Version: 2018.4

Comments
Atom

There is no sound on the 1st 2 slides

Alteryx Partner

Not letting me attempt the 3rd question, video hangs and then prompts to resume where left off, chose yes, hangs again and prompts to resume again - never ending loop.

Atom

Question 3 is not showing the correct answer.

Variable,operator and operand

Sr. Learning Strategy Manager
Sr. Learning Strategy Manager

@rajvivan

 

For question 3, the boxes of operator, operand, and variable need to be dragged into the green outlines in the correct order. Is it still marking your answer incorrect?

 

Alteryx
Alteryx

I got to 86% complete on this module and then it crashed.  Each time I tried to restart from where I left off it crashes again....and again...

Alteryx
Alteryx

This one keeps getting hung up right after the question about both conditions.  The answer is "And" however the lesson gets hung up right after submitting the answer.  

Atom

The screen hangs... and no sound/visual on 1st slide. I can't seem to proceed to next slide - hanging.. I'll move on to another module in the meantime.

Meteoroid

Where Can I find Sample Data  Files to practice along with you.

Atom

Hung up after 2nd question.

Meteor

Thanks for this video !

Atom

I cleared this tutorial video so many times but still status is not getting updated in the learning portal. Every time it is looping out.

Atom

Still broken after question 2 on the quiz

Meteor

unable to get to 100% due to a site glitch with this lesson...

Atom

Hung up after 2nd question.

Not working after 2nd question

Sr. Learning Strategy Manager
Sr. Learning Strategy Manager

@kdziekonska@ian90 -  we will check it out!

This lesson is still broken after lesson 2.

 

I was able to get past question 2 by restarting lesson in Chrome instead of Microsoft Edge.

Atom

I got to 86% complete on this module and then it crashed.  Each time I tried to restart from where I left off it crashes again....and again

Atom

It works with chrome but not with edge. So use chrome to complete it with no issues.

what about adding an option to filter out blank or completely null records? It's 1 click in PowerQuery, but I do not know how to make it in alteryx other than using complex condition isnull( column1) and isnull(column2) etc, which is annoying if you have 58 columns.

Atom

Sound is not working on three of the slides.  Was not able to complete this module

Atom

Not able to complete this session. Everything goes on mute and no video after few secs

 

Atom

No Video is running and no Sound

 

Atom

Hi - I have the same issue as some others. The 3rd question starts but then it stops and then I get a message whether I want to continue where I left off. When I click yes, it starts the question again and stops and loops back to message. 

Atom

I get stuck in the same loop, so cannot finish the section.

It does not accept my answer on the Height of at least 10 meters tall.

Atom

Freezes when I type the boolean operator for the custom filters - I can't move past this.

Atom

problem with question regarding >= 10  in custom filter section.  cannot progress past this point. please fix.

Atom

Seems to have fixed itself once I posted the comment seeking help. go figure. 

Does not let me select the filter 'Health Equals Good' this is case sensitive and should has to be entered as 'Health Equals good'