topic Re: File delimited Metadata/Schema - Data Types in Talend Studio

File delimited Metadata/Schema - Data Types

Anonymous — Sat, 16 Nov 2024 07:24:11 GMT

Hi!

I'm very new to Talend (Talend Open Studio for Data Integration 7.0.1). Hoping to use it to simply move data from a delimited text file to a SQL Server database.

My issue is when creating the Metadata for the "File delimited", I'm wanting Talend to NOT determine the data type (Step 4 of 4 - Define the Schema in the wizard). I'm wanting everything to be "Strings".

Instead it appears to be determining what the type should be - and is causing me issues later when I map the data. I understand I can go one-by-one and change each one on that screen (Step 4 of 4), but I'm talking very many files, with hundreds of fields in each.

Is there a setting or something I can set to make all the fields in my File delimited schema to be defined as "Strings" ?

Thanks in advance!

Re: File delimited Metadata/Schema - Data Types

TRF — Thu, 25 Oct 2018 21:12:41 GMT

What if you set the limit to 1 on step 3 of 4?
Else, using files with just the header line should work.

Re: File delimited Metadata/Schema - Data Types

Anonymous — Fri, 26 Oct 2018 16:48:43 GMT

Hi TRF -

Using the file with just the headers (and then putting the data back afterwards) - worked. Not the perfect solution - but it does work! Thank you!!

Re: File delimited Metadata/Schema - Data Types

TRF — Fri, 26 Oct 2018 19:16:00 GMT

Great!
Don't forget to mark your case as solved.