Column names

Follow

Ganesh Saptharishi

• October 22, 2021 12:48

I am in the process of capturing the rules we have employed in our workbooks.  Worksheet info gives the details of rules but not column names.  all i could see is column 1:= (formula).  Is there a way to get the column names of a workbook easily.  currently I add the worksheet to a new workbook, take a sample of 10 rows and then download them to get the column names which is quite tedious for many work books.

 

Appreciate if there is a simpler solution.  I am not familiar with Rest API etc and i am not the admin as well.

 

suggest a suitable option.  Thanks in advance

0

• 

  Konsta Danyliuk

  • October 22, 2021 12:54

  Hello Ganesh.
  May I ask you to provide more details on the use case, please.

  • What is the ultimate goal of this exercise? How are you going you use a Sheet's columns details?
  • What Datameer version do you use?
  • At what exactly menu do you see 1:= (formula)?

  Thank you.

  0

  Comment actions Permalink
• 

  Ganesh Saptharishi

  • October 23, 2021 12:00

  hi Konsta,

  Thanks for your reply.

  ultimate goal is to capture the business rules and create a master inventory of business rules.

  7.5.X is the version.

  for example if execute ALT+i for worksheet info page  and I can see the formula applied on the sheet.  example if at column 1 there is a groupby(region) is applied the information sheet shows Column 1: groupby(region). The difficulty here is I also would like to capture the actual column names instead of the column numbers.  Hope this helps.  Again thanks for your help

  0

  Comment actions Permalink
• 

  Konsta Danyliuk

  • October 25, 2021 08:49
  • Edited

  Hello Ganesh.
  In newer Datameer versions, we removed the Workbook Info page and moved the Sheet column details to the Columns section of the Inspector tab. This is where one now could see the column's names and the formulas they contain.

  

  Another method you could use to get a Workbook's structure, including column names and formulas, is by viewing the JSON definition. To do so, you need to put /rest after the port at the browser address string when you have the Workbook open.

  

  0

  Comment actions Permalink
• 

  Ganesh Saptharishi

  • October 26, 2021 05:29

  Hi Konsta,

  Thank you very much for this.  Surely this helps. one another question.  now that I have the JSON definitions, is it possible for me to change the formula for multiple columns on the JSON file and use the same in datameer?

  Ganesh

   

  0

  Comment actions Permalink
• 

  Konsta Danyliuk

  • October 26, 2021 06:41

  Hello Ganesh.

  Yes, you could make changes directly in a JSON definition and then update an existing artifact or create a new one via REST API. There is also a REST API call to gather JSON definition, so you do not need to copy it from the browser.

  Please walk through Accessing Datameer Using the REST API section of our documentation for further instructions. You do not need Datameer admin privileges to use REST API.

  0

  Comment actions Permalink

Please sign in to leave a comment.