I am pulling data from a Google Sheets API call that has some rows of data with multiple names separated by a comma. I want to write a query to select all the individual names.
I want to split the string by a comma, but it appears that ALASQL does not support STRING_SPLIT. Is there another way to split my data?
I recently had an AlaSQL related question that dealt with a comma delimited string. @Kabirdas came up with a bit of syntax that solved my problem. To be honest I have no idea how or why it worked, but it may give you a string to pull and solve your problem:
The other option would be to use a transformer on your SQL to post process the results, looping through each record and using .split() to convert your string into an array.