Create report OR DataMesh to pull information from MetaData Worksheets

PeggyLang

I have a client ask for a report.  There are 150+ stores involved in the report.  MOST of the information I need for the report can be found in each of the MetaData sheets.  The challenge however, is that the MetaData sheets are buried two folders deep in the Workspace.

How do I either create a report or a DataMesh that will 'drill' down in workspace then folders to get to the worksheet where the data is?

 

Lucas Rayala

Hi @PeggyLang -- you have to manually select the sheet using either the report or Datamesh functionality. The only way to automate this is via the API, and you would need a programmer to write the code.