Transform columns into a positional line

[xrocq]

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

[Anonymous]

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

Regards
Shong

[xrocq]

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   "

[uzix · Accepted solution]

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

[xrocq]

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.

[uzix]

you can do it via java,for instance

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

[xrocq]

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"