I have a DB table which stores ( as a string ) values in an array. I don't like it, but I don't have any say in the matter nor do I have access to the DB to rework it there.What I'd like to do is query the table ( e.g. select ID, Name, ArrayField f...
Any why to add filter to business schema that created without analyzer ??
We noticed that starting in 2023.7 we are getting error messages in the loader status, if the Enforce Primary Key Constraint option isn't selected with Primary keys setup in the table. Screenshot below. Someone on our team asked why we even need pri...
If I have a site and I want to bucket visitors in to 'Super Active,' 'Active,' 'Kinda Active,' and 'Meh' based on a rolling n-day window of activity ( e.g. 30 visits is 'Super' 2 is 'Meh' )That seems pretty straightforward for a given end date ( alth...
I'm trying to build a formula column. Using the lookup() function, but I don't suspect that's meaningful to this question. - The schema has 45 tables in it. Only 9 of them show up in the expression editor's dialog box ( left side ) - Of the 45 ...
