Filtering Data

[JoeM]

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

[dbranson]

There is no sound on the 1st 2 slides

[bpereira]

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.

[rajvivan]

Question 3 is not showing the correct answer.

Variable,operator and operand

[JoeM]

@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?

[SimonH]

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...

[PatrickF]

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.  

[raquel]

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.

[Ashfaq184]

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

[Ashfaq184]

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

[Rima]

Hung up after 2nd question.

[AlexandreCB]

Thanks for this video !

[PoliB]

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.

[Jwhittle]

Still broken after question 2 on the quiz

[Ninja64]

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

[ian90]

Hung up after 2nd question.

[kdziekonska]

Not working after 2nd question

[JoeM]

@kdziekonska, @ian90 -  we will check it out!

[WillTravelForData]

This lesson is still broken after lesson 2.

[WillTravelForData]

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

[Sjohal]

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

[Sjohal]

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

[Sjohal]

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

[sheloveaaa]

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.

[Joel1]

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

[sohanlal]

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

[sohanlal]

No Video is running and no Sound

[mettep00]

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. 

[Chrisd1]

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

[joyejaucian]

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

[Ngshep]

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

[Jad]

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

[Jad]

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

[jewanalemao]

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

[CsHind80]

Says that I am 92% done in spite of me having completed it twice! Anyone have ideas?

[ocaballe]

I can not make a quizz

[Jacque]

The video is hung up on the basic filter entry section after trying to enter "Good". No idea how to get it to go to the next page, even though I did as instructed.

[Sreenavya]

For the Basic Filter question in the Quiz, Inspite of dragging the column name operator and the value , I am getting my answer as Incorrect. Don't understand why .

[ChristineB]

@Jacque did you click the Submit button (check mark) in the player after entering your text in the box?

[ChristineB]

@Sreenavya Which values are you dropping into the spots for the column name, operator and operand? 

[ChristineB]

@ocaballe Are you unable to access the quiz section of this lesson?  Or are you having an issue with a specific quiz question?

[ChristineB]

@CsHind80 Is the lesson on your progress card not accurately reflecting your completion status?  Have you tried clearing your cache?  I'll look into our data to see if our back-end is capturing your completion of this lesson. 

[Jacque]

@ChristineB I was finally able to get past the point by restarting the video and waiting until it was absolutely finished presenting to start and submit my answer.

Thanks.

[ChristineB]

Thanks for letting me know @Jacque !

[x2tjbrow]

Hello @ChristineB,

The quiz selection is not allowing me to select any of the answers for each problem. Is there a solution for this? 

Thankyou

[ChristineB]

Thanks for your feedback, @x2tjbrow.  I think I experienced something similar when I resumed this lesson.  Once I cleared my cache, I was able to proceed through the quiz and interactions as normal.  Try clearing your cache and see if that helps!  In the meantime, I'll continue to investigate.