topic Re: Create schema from flat file in Talend Studio

Create schema from flat file

borrisbeck — Mon, 11 Feb 2019 17:48:45 GMT

I have a flat file with more than 300 columns. I don't want to manually type all the columns in the schema. But the schema itself is in a positional file, so from this, Is there a way to create schema's from a flat file containing the layout?

Re: Create schema from flat file

akumar2301 — Mon, 11 Feb 2019 19:17:28 GMT

You can create metadata from a flat file and then use the metadata while creation of job

https://help.talend.com/reader/~R4Lk_SlELw9a8pKBKTm9A/6_DXzUBalUwPr43xSp3DlQ

Re: Create schema from flat file

borrisbeck — Mon, 11 Feb 2019 20:08:54 GMT

My file doesn't have any headers, the whole metadata information is in a separate positional file, that's why i'm looking for a solution to "create a schema from a file". I came across this link, but it seems like i need to change the schema file layout,
https://help.talend.com/reader/qsVMGPxPzq7IQ_Tij2uz2g/tdFCC75bGtNkQSR~gwighA

Re: Create schema from flat file

akumar2301 — Mon, 11 Feb 2019 20:25:24 GMT

Yes if your metadata in in separate file , you could use above method and it has a strict schema def.