Loading Profile...
I have a text file with NO deliminters, but I have another file with the names and offsets of the fields in the first file. How can I use the Load Metadata From File button on the Metadata Editor to load the column names from an external file?
I have a COBOL COPYBOOK if it helps. Joe D
Help get this topic noticed by sharing it on
Twitter,
Facebook, or email.
Twitter,
Facebook, or email.
Loading Metadata from External file
-
Hello Joe,
it is an interesting question, but I am afraid this function won't help you. The Metadata references to our syntax of Metadata, what is a xml file with the same name as a text file with an additional .metadata extension. This is how we save the settings of Metadata editor and the function is for example for reusing the metadata between different files with the same structure.
Even it is possible to generate the file on your own (you get into its syntax quite easily), I advice you to use the Metadata Editor, choose "Fixed" as a file type on the top of the dialog and use the tool "Set Fixed Widths" to manually set the offsets for each column.
If you are intersted in xml syntax of the files for generation of the metadata files, feel free to ask for an explanation and I'll write it for you. -
-
Hello Joe,
yes, send me the metadata files and I'll try what can be done with it. We may try to transform the metadata or display them and copy paste the names directly into Fixed With File Reader step and skipping the Metadata editor in case you have such amount of columns in the text file.-
Martin,
I want to send you the metada but your email noreply.ataccama@getsatisfaction.com probably won't get to you.
Do you have another email for me to send to?
Thanks,
Joe -
-
-
-
-
Of course, sorry, please send it to martin.landa@ataccama.com
-
EMPLOYEE
I would like to avoid having to enter 99 col names. Since I already have them in an XSD is it possible to get DQ Analyizer to recognize the XSD for this text file?
Joe
PS. I can send you a subset of this fixed length file and the XSD and COBOL record layout if you desire.