- 115
- 124 582
Mark Frisch
United States
เข้าร่วมเมื่อ 4 ส.ค. 2015
Are you passionate about Alteryx? I'm trying to create some helpful content. Please feel free to give me your feedback. I think that this TH-cam thing is going to be big one day.
Enso - Magic Joining Powers
🔍 Mastering Complex Data Joins with Enso! 🔍
Hey Data Enthusiasts! 📊
Ever faced the challenge of joining datasets with multiple criteria? Let's dive into an advanced example where we combine apartment ownership data based on:
Exact Case Match on Owner
Case-Insensitive Match on Apartment Name
Date Range Match to ensure ownership records fall within specific periods
Here’s a quick rundown of how we did it:
Datasets:
Apartment Information: Contains details like Apartment Name, Location, Owner, and Ownership Dates.
Ownership Data: Time-series data tracking changes in ownership.
Join Criteria:
Exact Case on Owner
Case-Insensitive on Apartment Name
Date Range using Date between StartDate and EndDate
Watch the video for the suprising simplicity of the solution !!!
I'll post this to community.ensoanalytics.com/home shortly ...
Hey Data Enthusiasts! 📊
Ever faced the challenge of joining datasets with multiple criteria? Let's dive into an advanced example where we combine apartment ownership data based on:
Exact Case Match on Owner
Case-Insensitive Match on Apartment Name
Date Range Match to ensure ownership records fall within specific periods
Here’s a quick rundown of how we did it:
Datasets:
Apartment Information: Contains details like Apartment Name, Location, Owner, and Ownership Dates.
Ownership Data: Time-series data tracking changes in ownership.
Join Criteria:
Exact Case on Owner
Case-Insensitive on Apartment Name
Date Range using Date between StartDate and EndDate
Watch the video for the suprising simplicity of the solution !!!
I'll post this to community.ensoanalytics.com/home shortly ...
มุมมอง: 33
วีดีโอ
Getting Started Exercise 4
มุมมอง 7421 วันที่ผ่านมา
This video quickly (6 minutes) walks you through the completion of Enso, Getting Started Excercise 4. Some of the key take-aways are that you can JOIN "BETWEEN" two dates with ease and when you look at a completed workflow, you can read the configuration of all components without having to individually review each one. As always, your feedback is welcomed. Cheers,
Enso Read of Multi-Row Excel Header
มุมมอง 71หลายเดือนก่อน
Have you been challenged by reading Excel files into your workflows before? More specifically, a sheet where the header spans multiple rows in Excel? There are a variety of use cases like this (e.g. Year on Line 1 and Month/Day on Line 2) and I wanted to see how to accomplish this read using Enso. Not to worry, I've also sent the idea to Enso to improve the product with a native read option to ...
Preppin' Data Challenges 2024-Week21
มุมมอง 36หลายเดือนก่อน
Solved in Enso, I am getting more fluent in creating workflows. My confidence is building. I'll answer the post with more details (community.ensoanalytics.com/c/preppin-data-challenges/preppin-data-2024-week-21-solved-in-enso). JOIN is "automagically" configured - I really like this CROSS_TAB is an improvement over Alteryx FORMAT is a simple way to see the data in a preferred mask. Including a ...
Enso Adventure 2
มุมมอง 22หลายเดือนก่อน
Enso is approaching G.A. (you can download and use it now) and their community adventures are open for you to try. Setup an account and see what the future holds for Enso. In Adventure 2 you'll read data from multiple sources and join it to produce Sales B/(W) results. community.ensoanalytics.com/c/weekly-adventures/weekly-adventure-2
Enso Adventure 1 - How To
มุมมอง 34หลายเดือนก่อน
Exploring Enso with "Enso Adventure 1" community.ensoanalytics.com/c/weekly-adventures/weekly-adventure-week-1 Let's look at this data challenge and see how it can be solved using Enso (you can download at enso.org/). I'm using the Windows version, but you can try it with macOS or Linux. The doors to Enso's community are open and the software is about to be G.A. It's free to try and they will v...
Enso Adventure 1: Overview
มุมมอง 65หลายเดือนก่อน
Exploring Enso with "Enso Adventure 1" community.ensoanalytics.com/c/weekly-adventures/weekly-adventure-week-1 Let's look at this data challenge and see how it can be solved using Enso (you can download at enso.org/). I'm using the Windows version, but you can try it with macOS or Linux. The doors to Enso's community are open and the software is about to be G.A. It's free to try and they will v...
Chaos Reigns Within - Delay A Second
มุมมอง 1099 หลายเดือนก่อน
Sometimes you need to DELAY data from processing for a specified amount of time (Seconds). This DELAY uses a Run Command Tool and executes a DOS timeout command. Set the DELAY and take a break (Block Until DELAYED). This macro was tested for execution with and without AMP on both designer and server. Multiple DELAY tools can be used in a single workflow. This macro supersedes the WAIT a Second ...
Chaos Reigns Within - Ensure Fields
มุมมอง 669 หลายเดือนก่อน
The "Ensure Fields" macro gives you the ability to create fields if they are missing in the incoming data. Example use cases include: - Use after an input tool to make sure that the incoming data contains the mandatory data element - Use before a UNION tool to establish the common data element - Use after a crosstab tool to create a field for a missing value Find the macro here: marketplace.alt...
Chaos Reigns Within - Expect Zero Records
มุมมอง 269 หลายเดือนก่อน
When data is NOT expected, yet rows exist you need to know that there is a problem. This macro requires no configuration and it tests for more than 1 or more records. Download it here: marketplace.alteryx.com/en-US/apps/420291/crew-expect-zero-records or bit.ly/CReW_Expect0Records (To install it copy it into the macros folder where you have the CReW macros installed on your machine. For example...
Chaos Reigns Within - Grouped Record ID
มุมมอง 459 หลายเดือนก่อน
The "Grouped Record ID" resets sequence numbers to your defined starting value for each change in key values. You can select one or many fields in combination to create your grouping structure. Download it here: marketplace.alteryx.com/en-US/apps/420292/crew-grouped-record-id or bit.ly/CReW_GroupedRecordID (To install it copy it into the macros folder where you have the CReW macros installed on...
Chaos Reigns Within - Only Unique
มุมมอง 959 หลายเดือนก่อน
When you need to identify records that have a unique set of values (across 1 or many columns of data), the Only Unique tool differentiates itself from the standard "Unique" tool by finding the truly unique rows of data. The standard "Unique" tool pushes the "First" of 1 or many records to the "Unique" output anchor. When you want the records that don't match to other records, this is a tricky f...
Chaos Reigns Within - Control Container Error Check
มุมมอง 889 หลายเดือนก่อน
INTRODUCING THE CONTAINER ERROR CHECK MACRO With this we now are very close to replacing the CReW Runner macros with Control Containers! All we need is the S and F outputs provided by the runner macros. We replace this with the Container Error Check Macro. You can download it from: marketplace.alteryx.com/en-US/apps/421102/crew-control-container-error-check or bit.ly/CReW_IFTTT (To install it c...
21 Week Journey Video
มุมมอง 45ปีที่แล้ว
See how I've transformed my health. Learn the 3 pillars that I've used to help me, my family and friends lose weight. It's simple and easy to follow.
Alteryx can now encrypt with SHA256 courtesy of CReW
มุมมอง 454ปีที่แล้ว
Alteryx can now encrypt with SHA256 courtesy of CReW
Alteryx - Hello, World! (Rube Goldberg)
มุมมอง 1422 ปีที่แล้ว
Alteryx - Hello, World! (Rube Goldberg)
Alteryx Runner | List Runner Conversion Kit
มุมมอง 2.3K2 ปีที่แล้ว
Alteryx Runner | List Runner Conversion Kit
Parallel Block Until Done (without CReW macro)
มุมมอง 2.3K2 ปีที่แล้ว
Parallel Block Until Done (without CReW macro)
Alteryx Weekly Challenge #92 - The Blob
มุมมอง 3833 ปีที่แล้ว
Alteryx Weekly Challenge #92 - The Blob
MarqueeCRew Quick Lesson - Remove Commas in Results
มุมมอง 1.5K3 ปีที่แล้ว
MarqueeCRew Quick Lesson - Remove Commas in Results
MarqueeCReW Quick Lesson CReW Labelled Block Until Done
มุมมอง 2433 ปีที่แล้ว
MarqueeCReW Quick Lesson CReW Labelled Block Until Done
Love this Mark!🔥🔥🔥
Hey - great to see your new video @MarqueeCrew!
Thanks! I'm thinking outside of the box and giving lots of direct feedback to the Enso team.
Fantastic work on solving the Preppin' Data Challenge using Enso! 🎉 Your approach to solving this one was incredibly innovative and insightful. It's always inspiring to see how our community leverages Enso to tackle complex data challenges in such unique ways!
Love this Mark! Thank you for created such a quick overview on solving one of the Preppin' Data challenges in Enso!
what about if i have like 50 records in the source? it display an error
hi, where i can find the link?
thanks <3
actually that's the behavior regardless of data type/format. Darn. I also tried running AYX as admin, same result.
Hi Mark, i've noticed that if i feed this tool url strings it outputs text records that say "no data". Any thoughts?
Hi Thanks for sharing useful information, now you have opened a Pandora box. I would like to know more, please. I followed the steps in the above video and the new workflow runs like magic all the workflows are successful however, my 1st alteryx workflow which should produce the Excel file which does not produces Any trick or solution? 🙏
A desired feature to save yourself being lost in long column list and prvent from scrolling sideways multiple times to see the effect of the formula.
Thankyou
hi, how can i remove special character from data in alteryx
i got this from ur replies . now have question that how do i parse value after fullstop and hyphen
Video not clear
Interesting! Thank you so much for sharing
Nice Job!
Nice job Mark! And it's great to hear Steve saying "We can distribute a theme pack..." (~16:33)
It's a good one, Mark. It can be a time saver.
Question: The list runner runs a list of jobs, right? So, what would the benefit be of a batch macro using the runner tool. Aren't you simply recreating the list runner? I'm sure I'm missing something quite obvious. Thanks!
You are spectacular, Mark! Keep up the great work. This video has so much depth and teaching moments. Thanks for sharing it.
Glad you enjoyed it! Coming from you, this means a lot. Cheers!
Video not clear
Brilliant energy!
love it!
Hello Sir, thanks so much, one quick question, suppose if field 1 is also different, then how will the workflow look like, can you please explain that as well.
Muy practico el video, GRACIAS
I enjoyed this one! Great job Mark😁
Can you get some Calgary in there too?
why won't crew macros work in Alteryx Server?
Thanks for the video it's useful. For the batch macro I am getting an error "SupportingExes\AlteryxRunner.exe" returned an error code: -1". I have put SupportingExes folder and the exe in the same folder as my mapping.
Thank you Mark
Thanks always for your contributions and generously shared know-how. I'm hoping for more Alteryx embrace of the Crew conditional macro. And I'm hoping for more control of order with hinted improvements to containers.
Hello can you contact me on how to make the date macro you used
Thank you very much, very helpful
The video quality at the 2:33 mark is blurry!
Very good explained. Loved it 👍.
Voice Quality is not good
It looks as all of you enjoyed it :)
Nicole keeping it real with the Dino nuggets. Awesome.
Hi Mark I have massive work flow when i click on connect the tool where i want to connect pops up in the list but even after selecting the appropriate terminal to connect to ... Connect tab remains disabled .. any idea how to work around this problem
seeing would be helpful. please try a post to community and let's see what it is. You can tag @marqueecrew. Also, if the workflow is massive, is that really needed? ChaosReignsWithin.com and CReW macros might help.
Mark, awesome and great information. As you know, "Nothing in LIFE is given to you for FREE, you must #gogetit"
Absolutely! #GoGetIt works for me <3
This guy is awesome ... He shares valuable tips that many of us don't know
Wow, 9.5 seconds. Impressive!
Great stuff, thanks Mark!
This is a great tip thanks Mark!
Great tips, as always Mark! Thanks!!!
Thank you so much.....I was all the way looking for this but just didn't know how to look for.....I was stuck finding solution using transform tool🤦♂️
poor video quality
yes I do see same issue
I really liked this introduction. But I have a question... what If I have a column with strings like 24102020 and I would like to transform it into a date? 24/10/2020? How can I do that? Anyone?
Hi Mark, How to apply macro on the same workflow and also what if the number of sheets are not fix ,do we need to go everytime into the tool to change it? Thanks
Well explained! Thank you!