1"use strict";(self.webpackChunkdataedo=self.webpackChunkdataedo||[]).push([["10412"],{16464:function(e,t,a){a.r(t),a.d(t,{frontMatter:()=>i,default:()=>h,toc:()=>c,metadata:()=>n,assets:()=>d,contentTitle:()=>l});var n=JSON.parse('{"id":"data-governance/reference-data/export-reference-data","title":"Export Reference Data","description":"","source":"@site/docs/data-governance/reference-data/export-reference-data.mdx","sourceDirName":"data-governance/reference-data","slug":"/data-governance/reference-data/export-reference-data","permalink":"/data-governance/reference-data/export-reference-data","draft":false,"unlisted":false,"tags":[{"inline":true,"label":"Metadata management","permalink":"/tags/metadata-management"},{"inline":true,"label":"Reference Data","permalink":"/tags/reference-data"}],"version":"current","lastUpdatedAt":1783594224000,"sidebarPosition":0,"frontMatter":{"id":"export-reference-data","title":"Export Reference Data","description":"","sidebar_position":0,"tags":["Metadata management","Reference Data"]},"sidebar":"tutorialSidebar","previous":{"title":"Reference Data in Dataedo","permalink":"/data-governance/reference-data/"},"next":{"title":"Reference Data in Dataedo Portal","permalink":"/data-governance/reference-data/reference-data-in-dataedo-portal"}}'),r=a(85893),o=a(50065),s=a(88046);let i={id:"export-reference-data",title:"Export Reference Data",description:"",sidebar_position:0,tags:["Metadata management","Reference Data"]},l=void 0,d={},c=[{value:"Lookups in HTML Export",id:"lookups-in-html-export",level:3},{value:"Lookups in Excel Export",id:"lookups-in-excel-export",level:3},{value:"Object per sheet template",id:"object-per-sheet-template",level:5},{value:"Type per sheet template",id:"type-per-sheet-template",level:5}];function p(e){let t={em:"em",h3:"h3",h5:"h5",li:"li",p:"p",ul:"ul",...(0,o.a)(),...e.components};return(0,r.jsxs)(r.Fragment,{children:[(0,r.jsx)(t.h3,{id:"lookups-in-html-export",children:"Lookups in HTML Export"}),"\n",(0,r.jsx)(t.p,{children:"Dataedo allows you to share lookups via HTML files."}),"\n",(0,r.jsx)(t.p,{children:"Use the Export function, select the HTML format, and select the databases and Subject Areas that you want to export. If you want to export Lookups, select them on the Choose objects step. Here is what you will find in the exported file:"}),"\n",(0,r.jsx)(t.p,{children:"Lookup detail view:"}),"\n",(0,r.jsxs)(t.ul,{children:["\n",(0,r.jsx)(t.li,{children:"Lookups node in the explorer tree. (1)"}),"\n",(0,r.jsx)(t.li,{children:"Lookup Values \u2013 only values approved by the documentation editor (2)"}),"\n",(0,r.jsx)(t.li,{children:"Linked terms (3)"}),"\n",(0,r.jsx)(t.li,{children:"Linked columns (4)"}),"\n"]}),"\n",(0,r.jsx)(s.Z,{src:"https://dataedo.com/asset/img/markdown/docs/export-reference-data/19aa97ffc75c3ee0766c1132a0168b06.png",width:"60%",alt:"Image title"}),"\n",(0,r.jsx)(s.Z,{src:"https://dataedo.com/asset/img/markdown/docs/export-reference-data/c4d37f4248a9e2f944361eb3d3979955.png",width:"60%",alt:"Image title"}),"\n",(0,r.jsx)(t.p,{children:"In the Columns section, you can find information if the table contains columns linked to the Lookups."}),"\n",(0,r.jsxs)(t.p,{children:["Example: table ",(0,r.jsx)(t.em,{children:"Products"})," (1) containing column ",(0,r.jsx)(t.em,{children:"ProductName"})," with linked ",(0,r.jsx)(t.em,{children:"Products"})," Lookup (2)."]}),"\n",(0,r.jsx)(s.Z,{src:"https://dataedo.com/asset/img/markdown/docs/export-reference-data/2707427c0bacc3d7f9634afa8dbd6230.png",width:"60%",alt:"Image title"}),"\n",(0,r.jsx)(t.p,{children:"Each term with a linked lookup has information about it in the Lookups section."}),"\n",(0,r.jsx)(s.Z,{src:"https://dataedo.com/asset/img/markdown/docs/export-reference-data/b912c8974bc1dee11432d0318a7a6e2d.png",width:"60%",alt:"Image title"}),"\n",(0,r.jsx)(t.h3,{id:"lookups-in-excel-export",children:"Lookups in Excel Export"}),"\n",(0,r.jsx)(t.p,{children:"You are able to export your values to an Excel file by selecting Export to Excel from the toolbar above the Values grid."}),"\n",(0,r.jsx)(t.p,{children:"Lookups export can also be part of Export from the ribbon Import/Export section. The wizard is very similar to the one for HTML."}),"\n",(0,r.jsx)(t.p,{children:"Below there is an example of what you will find in the exported file."}),"\n",(0,r.jsx)(t.h5,{id:"object-per-sheet-template",children:"Object per sheet template"}),"\n",(0,r.jsx)(t.p,{children:"Sheet with all Lookups listed:"}),"\n",(0,r.jsx)(s.Z,{src:"https://dataedo.com/asset/img/markdown/docs/10/export-reference-data/2ebe06b410fceb9209207058af05b9c2.png",width:"60%",alt:"Image title"}),"\n",(0,r.jsx)(t.p,{children:"Sheet for each lookup separately with sections:"}),"\n",(0,r.jsxs)(t.ul,{children:["\n",(0,r.jsx)(t.li,{children:"Lookup properties (1)"}),"\n",(0,r.jsx)(t.li,{children:"Values - only values approved by the documentation editor (2)"}),"\n"]}),"\n",(0,r.jsx)(s.Z,{src:"https://dataedo.com/asset/img/markdown/docs/10/export-reference-data/64ada7840d726583051f77cec244cab7.png",width:"60%",alt:"Image title"}),"\n",(0,r.jsx)(t.h5,{id:"type-per-sheet-template",children:"Type per sheet template"}),"\n",(0,r.jsxs)(t.p,{children:["The sheet with all Lookups listed is the same as in ",(0,r.jsx)(t.em,{children:"object per sheet template"}),"."]}),"\n",(0,r.jsx)(t.p,{children:"Sheet with all Lookup values from all exported lookups (some of them were hidden from the view below):"}),"\n",(0,r.jsxs)(t.ul,{children:["\n",(0,r.jsxs)(t.li,{children:["Sample values from ",(0,r.jsx)(t.em,{children:"Countries"})," Lookup (1)"]}),"\n",(0,r.jsxs)(t.li,{children:["Sample values from ",(0,r.jsx)(t.em,{children:"Currencies"})," Lookup (2)"]}),"\n",(0,r.jsxs)(t.li,{children:["Sample values from ",(0,r.jsx)(t.em,{children:"Units of measurement"})," Lookup (3)"]}),"\n"]}),"\n",(0,r.jsx)(s.Z,{src:"https://dataedo.com/asset/img/markdown/docs/10/export-reference-data/000db45729133e16a6cbf44bf539449c.png",width:"60%",alt:"Image title"})]})}function h(e={}){let{wrapper:t}={...(0,o.a)(),...e.components};return t?(0,r.jsx)(t,{...e,children:(0,r.jsx)(p,{...e})}):p(e)}}}]);
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.