Talend community forum / Post a reply

Open Data SolutionsData Management solutionswarehouseOpen StudioBusinessExtract Transform LoadETL

You are not logged in.

Announcement

[2013-05-06] Boston Area User Group Meetup
[2013-05-02] NOTICE TO ALL TALENDFORGE USERS: maintenance completed
[2013-04-26] Talend Open Studio's 5.3.0 release is available
[2013-04-12] Ready for testing - Talend Open Studio's 5.3.0RC2 release is available
[2013-04-11] Talend’s corporate pages and groups on social media

Unanswered posts

Connecting [...] by Newbie to development
parseDate change from 5.0.3 to 5.2.2? by Kwags300
Problem whit context variable in query. by Ginetto
Problem with SELECT a.name AS a_name, b.name AS b_name input by kacper
Component to Connet,Retrieve data from MS OLAP Cube by talend_bso1
SayHelloRoute [...] by gary.liu1119@gmail.com
How to generate jar for use with tBRMS by adaemus

Index
» Usage, Operation
» how to transform a flat file with multiple lines in one..

Post a reply

Topic review (newest first)

pedro: 2012-05-10 11:41:37

Hi Bruno

I think you might forgot to add context variable 'id' and 'seq' in your job.

Regards,
Pedro

ironman34: 2012-05-10 11:38:34

Hi,

I try this solution but I still have some errors in the Java stage i think....

Error in the component's properties:

id can not be resolved or is not a field

seq can not be resolved or is not a field

seq can not be resolved or is not a field

seq can not be resolved or is not a field

id can not be resolved or is not a field"

With the capture attached.

Thanks,

Regards,
Bruno

pedro: 2012-05-08 05:42:15

Hi Bruno

I create a new job which suits your requirement.

Code:

if(context.id.equals(input_row.id)){
 output_row.id = input_row.id;
 output_row.newColumn1 = Numeric.sequence(context.seq,1,1);
 output_row.newColumn = input_row.newColumn;
}
else{
  context.seq+="1";
   output_row.id = input_row.id;
   output_row.newColumn1 = Numeric.sequence(context.seq,1,1);
   output_row.newColumn = input_row.newColumn;
}
context.id = input_row.id;

Regards,
Pedro

ironman34: 2012-05-07 15:35:59

Hi,

After tests, this is not the right method.

In the delimited file, the second column( "PECU", "SOL"...) is dynamic and i can have 30 rows for an ID (ID is the first column :9031 or 9800) and only 6 for another. It couldn't be the same...

Exemple :

9031;PECU;152.56
9031;SOLE;896.45
9031;PENS;7896.45
9800;TOTA;89.25
9800;PECU;111.69

In the Tmap it should dynamic but I don't know how?

Thanks for the answer,

Regards,
Bruno

ironman34: 2012-05-04 07:05:41

Hi,
thanks for your answer. I try this today.

Regards
Bruno

pedro: 2012-05-03 11:55:16

Hi

Welcome to Talend Community!

You might create a job as the following image.

Regards,
Pedro

ironman34: 2012-05-03 11:10:51

Hello,

I have to transform a delimited file like this :

9031;PECU;152.56
9031;SOLE;896.45
9031;PENS;7896.45
9800;PECU;89.25
9800;SOLE;111.69
9800;PENS;1212.59

Into this file type :

9031;PECU;152.56;SOLE;896.45;PENS;7896.45
9800;PECU;89.25;SOLE;111.69;PENS;1212.59

Has anyone an idea because I'm lost!!!

Thank you in advance

Announcement

Unanswered posts

Post a reply

Topic review (newest first)

Code:

Board footer