Google Sheets SUPERSQL QUERY Function - Apps Script SQL AlaSQL UDF - Part 1
Vložit
- čas přidán 29. 08. 2024
- This tutorial covers how to create SUPERSQL QUERY Function in Google Sheets using Apps Script, AlaSQL and JavaScript. With this function we'll be able to execute SQL like statements on ranges of data, including join statements.
Series Playlist:
• Google Sheets SUPERSQL...
github.com/chi...
github.com/chi...
To understand this video you need to understand JavaScript array methods. You can learn about them in this playlist • JavaScript Arrays & Me...
#SUPERSQL #GoogleSheets #alasql
Just giving you another boost with the CZcams algo because you're an amazing teacher. Keep up the good work man
lol Thanks!
Todos hablan del virus pero este hombre sigue en lo suyo, Love u....
:)
Just amazing. No words to describe how useful your efforts are. Due to lack of database query language in GAS I used to make my own query functions painfully. hopefully I'll able to translate them with this solution.
This is phenomenal
Fantastic! Thanks a lot for this tutorial! Incredibly useful.
we need more people like you my guy :)
Just Genius you are man!! Thanks a lot
Yes, you are amazing! I've wanted to see if SQL could be used in Google Sheets and the way you approached this was fascinating! BTW, as I watched you searching for the error I was hopping up and down, raising my hand, hoping you'd see the extra right parin. You've probably found it afterward, no doubt.
I'm not sure if I've noticed it. Which line are you referring to?
@@ExcelGoogleSheets I went through your tutorial again and even replicated the script, but I'm not seeing where I thought there was an extra right parin. Here's the sheet URL I produced: docs.google.com/spreadsheets/d/1ntcijJ9vWzVy_Gt2Uchi_XGriTaUAICyTkQrhJF5DSI/edit?usp=sharing
Your column Section has an extra space in the end.
@@ExcelGoogleSheets Thank you so much! Didn't think about the header row for the table but removing the extra space fixed the issue in my sheet.
the best youtuber
Thank you for the video. I was just thinking about how to merge the data from the two tables.
I love love love your videos and content! Please keep it up!
Thanks!
Pretty awesome. Thanks.
for real amazing -- thank you
Buen tutorial
yes i do with mor tables , it works, but how to set the source as global lib for all used sheets and use directly from sheets syntax
You Sir do know your Craft!
Indeed...
Thank you very much
Thanks for watching
Hello, this function is very helpful, thanks.
I am trying to filter by date with "SELECT * FROM ? WHERE recordDate= "2023-07-12", but is not working. Can you help me with the correct sintax?
So you could theoretically update a master list from another sheet that has record changes?
Please, how to run a UPDATE sql comand using SUPERSQL? I need this so much ;)
Hey you can start Online classes and become pro like you. I will join but please keep prices affordable.
Very informative video sir. Just a small question. can we use cluses like "group by", "having" and also if I want the data in an "ascending" or "descending" order, can I use these conditions in query?
Yes, you can
@@ExcelGoogleSheets Can I refer to particular cell in "Where clause" ? e.g. "....select * from xxx where Month = $c$2" or something like this. (note : '$c$2' is cell with drop-down combo where I am selecting a month)
Hello, could you please suggest a solution for this?
@@ganeshborude8539 This video should show you how to add variables czcams.com/video/V9HiM3_n7NM/video.html
What's the data in that Month column?
Hello. I wonder if it is possible to do research in the spreadsheet with webapp. I have a very large online spreadsheet and it is slow to load data. I would just like a single line.
Tried this with latest version 2.5.0 but I can evem save tes5 cript file, showing error of unexoected token = online the class Transaction
Make sure under settings you have V8 enabled.
How to perform count function in apps script similar to countif fuction.
Hello,
I am getting this error message.
TypeError: cannot read property 'shift' of undefined.
I did test alasql by the following step, but still get that message.
May you please help me with this error. What am I missing?
I am using alasql version: 0.6.2
Thanks
When i try
var data = [ {a: 1, b: 10}, {a: 2, b: 20}, {a: 1, b: 30} ];
var res = alasql('SELECT a , SUM(b) as B FROM ? where a=1 GROUP BY a ',[data]);
Logger.log(res);
I got error message
TypeError: Cannot find function findIndex in object a. (line 9734, file "alasql")
could you help me, please
Can u pls tel me how to import data from metabase to google sheet with out downloading data pls reply I need to automate report no one Is helping
hi sir , is it possible to convert excel vba to google apps scripts... i have excel with vba, how to convert it to gas sheet
Unfortunately, you have to rewrite everything from scratch.
Hi, how can I do a Cross JOIN ? It seams is not possible. Thank you very much!
What's the formula you've tried?
What is the JavaScript IDE ?
Really like your videos, mine SUPERSQL installation didn't work, gave me a #Name? error saying Unknown function SUPERSQL. What could I have missed? Help please
Did you follow the steps in the installation video? If yes, just refresh the spreadsheet & try again.
@@ExcelGoogleSheets .Thank you for responding so quick. I refreshed and had the same error message. I am sure I followed the steps in the installation video but I will do it again. It may an administrative restriction. I appreciate you bro
can somebody help me? i can't find that alasql script :(
in video description
@@ExcelGoogleSheets thank you so much for your help. just in case you forgot instead of full join, full outer join works in sql :).