Six Stars

how to create mate data in talend

Hi Team,

 

I have txt file, i want to load in oracle table. Below is file format. It is possible to create meta data from below file contents in talend.

 

Report:212
date:21-02-2019
------------------------
no name col3
------------------------
02 sanajay sagar
03 xxx yyy

Report:213
date:21-02-2019
------------------------
no name col3
------------------------
05 zxz sa
06 ew qa

 

ID: 121
Row count: 4

 

Thanks

Shree

4 REPLIES
Moderator

Re: how to create mate data in talend

Hi,

What does your expected output look like?

In talend, you can centralize file metadata in repository. Here is online document about:TalendHelpCenter:Centralizing File Delimited metadata

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: how to create mate data in talend

Hi Sabira.

 

Thanks for your input.

 

Please find the attached file.

 

How to create metadata for file, This file is system generated am sharing sample file contents.

 

Thanks

Shree

Moderator

Re: how to create mate data in talend

Hello,

What does your expected output look like?

no;name;col3
02;sanajay;sagar
03;xxx;yyy
05;zxz;sa
06;ew;qa

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: how to create mate data in talend

Hi Sabira,

 

Yes, Below expected output.

 

no;name;col3
02;sanajay;sagar
03;xxx;yyy
05;zxz;sa
06;ew;qa

 

Kindly suggest how to implement or how to achieve this scenario.

 

Thanks

Shree