Hi all, what about if I had a fixed width file in the catalog with the first row as the header (in error). The column data comes in as one string which renders it unusable for profiling and DQ. How can I get these types of files into the catalog so I can use them in my monitoring project?
I have used VCI’s before to add headers to csv files in the catalog and they work well.
Kind regards
Des
Hi Des,
Indeed it looks impossible to specify any particulars on import of a file into the data catalog. For my understanding of the issue, is it just the header row that is a problem or the fixed width data rows as well? I suppose also the data rows will read as one string, so one catalog item attribute.
Kind regards,
Albert
Good morning
The first record is classed as the header and each row is one string. I do have an xml doc for each file I am trying to handle so I was wondering whether I could use an xml reader or parser in the desktop to create a spec or something like that. Unfortunately my knowledge of xml is non existent but only for now.
Kind regards
Des
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
