Data & Schema Discussions
The dataverse runs deep. Get help with connections, loading, schema development, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Array to columns ( or rows )

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...

RADSr by Captain
  • 162 Views
  • 1 replies
  • 0 kudos

Resolved! Why are primary keys important?

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...

JC_Data_Wizard_0-1696883505198.png

Activity with in window of time

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...

RADSr by Captain
  • 1280 Views
  • 1 replies
  • 0 kudos