The documentation ( link below ) says InQuery can be used either in an internal session variable or an InQuery filter operator and formula expression."What does this mean?" seems like a simple question, but there it is. When I drag a formula into a...
I had occasion to spin up a new cluster and see that it's v 2023.4.1 - I don't see release notes for that release yet, but would like to know which - if any - bug fixes are in it. I recently upgraded a customer and don't want to repeat that process r...
Doing some testing. I have two tables from the same source - they should be mutually exclusive result sets, but may not be. I created a third table using two SQLi -based tables to query the first two and set the key columns to eliminate any duplic...
I have a SQL statement with a long and convoluted backstory ( tl/dr - bug making me chase workaround ) and I've come across a potential solution using cast ( <column> as numeric ) See the animated GIF at the end of this post for the perplexing probl...
I have a list of products to which I want to assign categories and I'll want to repeat this process for multiple iterations.So I can build an insight: PRODUCT, <formula column w/ category text>The challenge is that I want to pick the category name fr...
