topic Transform columns into a positional line in Talend Studio

Transform columns into a positional line

xrocq — Thu, 20 Feb 2020 13:19:51 GMT

Hello,

I have to transform a column schema into a postional row to insert it in a db table.

But i cannot find a component (like the tFileOutputPositional) who is not making a file

For the moment the best thing i found :

Is there any component with the tFileOutputPositional options to configure a positional line from an inpunt schema ?

thx for help

Re: Transform columns into a positional line

Anonymous — Fri, 21 Feb 2020 05:19:55 GMT

@xrocq, I think I don't understand your question well, can you please take an example to explain your requirement?

Regards
Shong

Re: Transform columns into a positional line

xrocq — Fri, 21 Feb 2020 07:49:31 GMT

Sorry for my confused explanation,

My input is delimited= "name;surname"

What i need is a positional structure to insert in a DB like that = "name surname "

Re: Transform columns into a positional line

uzix — Mon, 24 Feb 2020 14:26:21 GMT

hello,

in tFileOutputPositional you have a schema defined , yes ? you can define therre the size for each column

copy that schema and use it in tFileinputpositional

Re: Transform columns into a positional line

xrocq — Mon, 24 Feb 2020 15:49:21 GMT

Hi uzix, thx for helping.

My objective is to not use file

In fact my input is a JSONB from a database and i have to transform it in a Positional structure and insert it in a VARCHAR column.

This is currently working with a temporary positional file (tFileOutput) structure but i'm looking for a way without using a tFile.

Re: Transform columns into a positional line

uzix — Mon, 24 Feb 2020 16:22:30 GMT

you can do it via java,for instance

System.out.printf("%s %s", "name", "surname");

Re: Transform columns into a positional line

xrocq — Tue, 25 Feb 2020 08:37:17 GMT

Thx for the idea but i prefer to keep the tFileOutputPositional step with the userFriendly setting table for every column of the schema, because the schema is heavy (200 columns).

I was looking for the same component without making a file like an hypothetic "tPositionalRow" or "tOracleOutputPositional"