SQL to get the sheet/column name dependency

Follow

Trupti Bhutada

• November 12, 2018 16:25

Hi,

I've a requirement to get the dependency list of columns from one sheet to other. We have developed few workbooks and during the development phase lot of columns have been added. However in higher levels we are not using all those columns. Can I get this information thru DAP DB SQL to see which columns are used and which are not. That way I can drop those columns safely.

Can someone have this in SQL format?

Thanks

0

• 

  Alan

  • November 12, 2018 20:20

  Hi Trupti,

  In the 6.4 release that your organization is on - the columns are stored in JSON format within the database.  In higher releases we do maintain a separate table to make doing what you are asking here easier.

  The best way to do this in your release is create a Data Link to the dap.sheet table and ingest the record_schema column - which contains the JSON of all the columns.  You can use standard Datameer JSON functions such as JSON_ELEMENT and JSON_VALUE to pull the values you need out for comparison.

  If you have further questions - I'd encourage you to open a case with support.

  Alan

  0

  Comment actions Permalink
• 

  Trupti Bhutada

  • November 14, 2018 09:20

  Thanks Mark. I guess I can use API to get list of columns as well

  0

  Comment actions Permalink

Please sign in to leave a comment.