Processing csv file to Postgres

Anonymous — Sat, 16 Nov 2024 06:31:01 GMT

Hi,

I have a csv file (attached) to load in my db table and I have this requirement based on a specific field:

In my CSV:

if field code_operator1=BETWEEN_START must exist code_operator2=BETWEEN_END

The problem is that in my Table I have only one field code_operator, instead in cvs I have code_operator1 and code_operator2. How can I insert code_operator2 after code_operator1 in the database column (code_operator)?

I have the same issue for code_entity and attr_value fields.

In need to find a way to insert data in my Table as follow:

uid	code_operator	code_entity	attr_value
1	BETWEEN_START	co1VTrns	0
2	BETWEEN_END	co1VTrns	99,99
3	BETWEEN_START	co1VTrns	150
4	BETWEEN_END	co1VTrns	199,99

Re: Processing csv file to Postgres

vapukov — Sat, 23 Feb 2019 10:55:06 GMT

Hi,

as variant - read file twice ind insert into database

uid - Numeric.sequence("s1",1,2)
code_operator - code_operator1
code_entity - code_entity1
attr_value - attr_value1

and second time:

uid - Numeric.sequence("s1",2,2)
code_operator - code_operator2
code_entity - code_entity2
attr_value - attr_value2

in this case, you will keep sequence for rows, BETWEEN_END will follow after BETWEEN_START

possible there are other solutions could be there

regards, Vlad

topic Processing csv file to Postgres in Talend Studio

Processing csv file to Postgres

Re: Processing csv file to Postgres