วีดีโอ

No problem!

If you're getting an error when you use the formula like you provide in your response, the first place I'd check would be to make sure your data types are consistent with your filter. In other words if you're sorting numeric values, make sure the data field is numeric.

My pleasure!

You're so welcome!

This one is one of my early ones from back in January. These days I add a comment about the Business Problem being addressed, and what the main tool focus is. Glad to hear you enjoy, and thanks for the comment. Maybe I can go back to some of my earlier ones and add the business question part.

Merci bien, tu est toujour gentil

Thanks for the visit

Thank you, good to hear.

Aishwarya, Each regex of instance is different, but I can explain this one a little more. The idea is, isolating each separate letter. If you open Regex, you'll see to the right of it a large "+" symbol in the section where you insert regex code. If you click on the "+", it expands various regex code you can readily insert by selecting. The very first choice on that list is a ".", with an explanation of 'Any Single Character'. This is what we need for 'this' flow. We want to isolate every character, and we select the "Tokenize" which essentially does a version of parsing, but allows us to parse that pattern to a separate row. Again, what we're looking for in this flow. It's impossible to explain every use of every regex in a video since Regex is effectively an entire programming language in it's own right and there are full websites devoted to it, and full courses on youtube or teaching channels (ie udemy, coursera, etc) on how to program Regex. The subject is huge, so I can talk to solving 'this' problem, but it's beyond scope to really do much more on 1 video. Hope this helps.

@@watermarkdata7048 ah- perfect ! Thanks so much .

Yes, I'd agree with you. That approach is probably easier. Lot's of ways to skin a cat. I've used/demonstrated that method in other videos. What you're proposing combines the ranking/filter. If you want to have the multi-rank ( 1, 2, 2, 2, 4, 5) it doesn't capture it. Really boils down to if you want to be have visibility to the 'n' sample size ranking as a separate piece of information or if you just want it to do it. Part of these videos is showing different ways to do the same thing.

Sorry I don't. I will probably look into it over the next few days.

Yes, you can absolutely use containers and achieve the same effect. Lots of ways to skin the cat. Gain the ability to move tools together and to minimize the box. Lose some of the flexibility on sizing the box, placement of tools in the box, and control of font used for description. Just a balance on what you'd prefer.

@@watermarkdata7048 Perfect and excellent work on these tutorials; I'll be spending some time here every weekend.

I"m not sure I understand your comment. Are you saying that "dd-MMM-yy" should be "dd-Mon-yy" instead?

@@watermarkdata7048 That's right

Thanks 👍

If you're talking about the first join where we also use count and gender you'd end up matching the max against every value for the year. Something you 'might' want to do if you were trying to get say maybe the difference between the count of every other name versus the highest/max. You add gender because 'that' specific value 'might' show up in both genders and you want to be sure you're making the right match.

Then you'd have had a tie for the name, used the most that year. Out of 'all' the names that could have been used, it would be insanely unlikely. Other circumstance you would could potentially bring back 2 records, and the other gender would show the same twice. At that point you'd have to decide based on what exactly it is you're identifying if you want to add an additional feature to create further delineation.

Not sure what your regex necessarily looks like, but try this : Regex Parse .*(\d{4}).*

Thanks for the support, glad it helped.

You can find the starter file in the alteryx community: community.alteryx.com/t5/Weekly-Challenge/Challenge-104-Love-s-not-the-only-thing-in-the-air/td-p/134546

More to come!

@@watermarkdata7048 hi. can i see what you put in your bat file to open a certain file? Thanks

Thanks a lot

J'allais essayer a mettre un photo de ton method, mais ce n'est pas possible. Mais, ca marche! En general il y a toujours des autre moyan a faire la meme chose. BIEN FAIT!

Data files for this challenge can be found in the community on line: community.alteryx.com/t5/Weekly-Challenge/Challenge-19-Excel-Record-Locator/td-p/36748

You're welcome!

Glad you enjoyed it

Wow, thank you!

Glad it was helpful!

Thanks for watching

Saad, Believe you're referring to this ==> datetimeformat("2000-"+padleft(tostring([M Cnt]),2,"0")+"-01","%b")? To convert it, yes, you need the whole thing. You're essentially fooling the system into believing you're working with a date with the Alteryx standard format of "yyyy-mm-dd" You're then telling the system that you want a specific piece of that date, the month in a 3 character format. That is what the "%b" portion is saying. Please reference the following web page for formats: help.alteryx.com/2018.1/index.htm#Reference/DateTimeFunctions.htm?Highlight=datetimeformat Scroll down to the table of "SPECIFIERS" for different formats you can work with.

@@watermarkdata7048 well thank you so much you have made it very clear thank you so much

Glad it was helpful!

Let me take a look for one of the challenges that leverages it, and I'll make a point to spend some on the tool specifically.

Mukesh, I just uploaded a video covering regex, Challenge #54

Thanks, will do!

Thanks so much for the kind comment Sebastian.