• Replies 11 replies
  • Subscribers 341 subscribers
  • Views 421 views
  • Users 0 members are here
Related

Using SQL to clean up CSI data

Brandi Cline
$organization

Has anyone had any luck using SQL to clean up CSI data that comes from TNEW custom forms?

We are using custom form data to collect information on our travel program participants when they register for a trip, which is great!  However, when you run a report on CSIs and export it, all the collected data comes across as one cell in excel.  I've used column splits in power query to separate everything out, but we'd love for the data to feed directly into a tableau, rather than being exported and then power queried.  I'm pretty new to SQL and completely self taught, so I didn't know if there was some way to make SQL do what the power query is doing.  The folks actually looking at and using the data don't use power query and only barely get into Tess for anything, so they currently can't get at the data themselves and certainly can't get it into a usable format.

Any advice would be appreciated! Slight smile

Thanks!

Parents
  • $organization

    Sure, it would be pretty simple to create a report to spit out the data in a specific format and assuming you have some sort of delimiter for the notes field, that should be no issue too. T_CUST_ACTIVITY is the table of interest. To find the description of some ids look in the tables below. Being that I am not 100% sure of the data in your CSI's and I'm hesitant to offer much more. Feel free to email though.

    select * from dbo.TR_CUST_ACTIVITY_CATEGORY 
    select * from dbo.TR_CUST_ACTIVITY_TYPE 
    select * from dbo.TR_SPECIAL_ACTIVITY
    select * from tr_origin
    select * from tr_contact_type

Reply
  • $organization

    Sure, it would be pretty simple to create a report to spit out the data in a specific format and assuming you have some sort of delimiter for the notes field, that should be no issue too. T_CUST_ACTIVITY is the table of interest. To find the description of some ids look in the tables below. Being that I am not 100% sure of the data in your CSI's and I'm hesitant to offer much more. Feel free to email though.

    select * from dbo.TR_CUST_ACTIVITY_CATEGORY 
    select * from dbo.TR_CUST_ACTIVITY_TYPE 
    select * from dbo.TR_SPECIAL_ACTIVITY
    select * from tr_origin
    select * from tr_contact_type

Children
No Data