IMPORTANT NOTES: 🔹 If you anticipate having NULLS in your query or get related errors, just add *On Error Resume Next* on a new line after the Dim statements in the function. It will return an empty string instead of an error. 🔹 This is the "easy but slow" version of this procedure which is great for small numbers of records or for use on a form to calculate and view each time a new record is presented. It will be slow in processing large numbers of records because a query must be run on each row. For a fast version of this procedure that is a bit harder to program but gives great results, check out my added material on this topic on Patreon to make it 100x faster: www.patreon.com/posts/speeding-up-with-73513312?Link& 🔺 Note that this procedure uses dynamic SQL which is fine for data wrangling, reporting, or personal use. For customer facing solutions, I would recommend converting this to use parameters for safety.
Great video Sean. Effective code and elegantly drafted as well. These are the kinds of videos that take the efficiency/shareability of one’s code to an entirely different level. Big fan of your work
IMPORTANT NOTES:
🔹 If you anticipate having NULLS in your query or get related errors, just add *On Error Resume Next* on a new line after the Dim statements in the function. It will return an empty string instead of an error.
🔹 This is the "easy but slow" version of this procedure which is great for small numbers of records or for use on a form to calculate and view each time a new record is presented. It will be slow in processing large numbers of records because a query must be run on each row. For a fast version of this procedure that is a bit harder to program but gives great results, check out my added material on this topic on Patreon to make it 100x faster: www.patreon.com/posts/speeding-up-with-73513312?Link&
🔺 Note that this procedure uses dynamic SQL which is fine for data wrangling, reporting, or personal use. For customer facing solutions, I would recommend converting this to use parameters for safety.
i like the way u say " i am your host sean mackenzie".
Really? I was going to cut that from future videos to save time lol!
I thought about the same. But did not tell him yet.
@@seanmackenziedataengineering Don't cut. It's your brandmark.
Great video Sean. Effective code and elegantly drafted as well. These are the kinds of videos that take the efficiency/shareability of one’s code to an entirely different level. Big fan of your work
Thanks, much appreciated!!
Super-duper. Thank u.
Buen trabajo!
Gracias
Gracias amigo!
Interesting video. Could be useful to develop a module for other manufacturers such as carpets, tiles etc.
That's a great idea!
Great video! How about one on field mapping (using a table to store mapping) when importing csv files.
Thanks for that suggestion! I'll add it to my list.
As always brilliant!
Thanks!
Is there a way to sort aggregated string alphabetically?
If you look closely, you'll see that it *is* sorted alphabetically :-)
Kindly make video on school fees system
Good idea for a small system. That could be a video series perhaps.
@@seanmackenziedataengineering thanks that will help me a lot
💯
Thanks!
Dynamite!
Thanks!