Column names

Follow
Ganesh Saptharishi

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

Comments

5 comments

Date Votes
  • Konsta Danyliuk

    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

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

    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

    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.

Didn't find what you were looking for?

New post