How to create a Data Dictionary and pull it into excel?
Article ID: KB0070257
Updated On:
| Products | Versions |
|---|---|
| ibi WebFOCUS | All |
Description
Description :
Take the following metadata and save it to an Excel spreadsheet
How to achieve this?
Take the following metadata and save it to an Excel spreadsheet
How to achieve this?
Issue/Introduction
How to create a Data Dictionary and pull it into excel?
Environment
All
Resolution
Resolution :
One way to do this as follows :
Go to the 'Workspaces' - (under any directory) - '+Content' - 'Others' - 'Text Editor' - '.Fex' editor and run the following snippet :
"""
CHECK FILE PRPMS HOLD AS HLDCAR
TABLE FILE HLDCAR
PRINT
TITLE
DESCRIPTION
FIELDNAME
ALIAS
USAGE
ACTUAL
SEGNAME
ON TABLE PCHOLD FORMAT XLSX
END
"""""
Once we run the code, an excel file will be downloaded which contains the file information.
One way to do this as follows :
Go to the 'Workspaces' - (under any directory) - '+Content' - 'Others' - 'Text Editor' - '.Fex' editor and run the following snippet :
"""
CHECK FILE PRPMS HOLD AS HLDCAR
TABLE FILE HLDCAR
TITLE
DESCRIPTION
FIELDNAME
ALIAS
USAGE
ACTUAL
SEGNAME
ON TABLE PCHOLD FORMAT XLSX
END
"""""
Once we run the code, an excel file will be downloaded which contains the file information.
Additional Information
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6367057116
Referred this form. it doesn't contains the exact answer but it will give some idea to write the snippet.
Referred this form. it doesn't contains the exact answer but it will give some idea to write the snippet.
Feedback
Yes
No
Powered by
