Talend community forum / tFileInputMSPositional - How to extract values from the component

Dinesh · 2009-10-27 22:07:05

Tags: [development, positional file, schema, tFileInputMSPositional]

I am Using the tFileInputMSPositional component to parse a text file which is multi schema. I able to extract those values using the tlogrow component. I am not able to extract these values from tFileInputMSPositional component to the other components as tmap. Please let me know your suggestions.

I am trying to extract header 1, header 2, body 1 and body 2 different schema values in a tmap.

Input File :

1 TEST FILE 20090724 188TEST COMPANY
5NEWCOMPANY 88999569111111205000001
6040102002016841 000000000011111 90724205
7USER1 111 TEST ST TESTCITY CA90000
8555995690000827 000000011111000001
9 000001 000000000000827 000000031111196

Uploaded Images

Last edited by Dinesh (2009-10-28 18:55:05)

shong · 2009-10-28 05:03:32

Hello

I am trying to extract header 1, header 2, body 1 and body 2 different schema values in a tmap.

I think you are tring to create a cycle flow in a job. You are not allowed to create a cycle flow in a job. See [Forum, topic 1468] multiple tAgregateRow and tMap components.

Best regards

shong

Dinesh · 2009-10-28 18:54:03

Hi Shong,

Can you please upload the image for extracting the header 1, header 2, body 1 and body 2 from tFileInputMSPositional component. The multi schema is configured in the same positional fine. Just to add header 1, header 2, body 1 and body 2 are different schema in the same file.

Dinesh · 2009-10-28 18:55:47

Shong,

I have also attached the schema defintion for the tFileInputMSPositional file

zguptn · 2009-10-29 03:06:52

hi Shong

Basically, what Dinesh is asking is that we know that Multishchema component gives records of different types (row_A_1, row_B_1, row_C_1) but is there a way we can combine any two of the outputs e.g. ca we combine row_A_1 and row_B_1. If yes, how ?

Thanks
Z

Uploaded Images

shong · 2009-10-29 03:20:32

Hello

but is there a way we can combine any two of the outputs e.g. ca we combine row_A_1 and row_B_1. If yes, how ?

Because you are not allowed to create a cycle flow in a job, so as a workaround, you can output the row_A_1 and row_B_1 to two temporary files first, and in the next subjob, using two tFileInputDelimited components to read the temp files again and merge them on tMap. In a job, you can use tCreateTemporaryFile to create temp file, the file will be deleted auto when the job ends.

Best regards

shong

jkrfs · 2010-07-12 22:30:39

Is this still the case for tFileInputMSPositional? I also have a multi schema positional file but every 7 rows is one entity. So basically I have to combine all 7 rows into one row. I know that I can export them into 7 temporary files, then re-import them and join them in either tmap or tjoin...but I was hoping there is a way around this. I am not sure as to why tFileInputMSPositional still does not allow me to aggregate rows...

jkrfs · 2010-07-13 14:51:37

I decided to export all 7 rows to different csv files and input them again. My current issue is that I am not sure how to combine them in tMap.

Each of the 7 rows/outputs/inputs = 1 actual row. Do I have to create an extra column to number them in the output so that I can match them in the tmap? Any help would be great.

Announcement

Unanswered posts

#1 2009-10-27 22:07:05

tFileInputMSPositional - How to extract values from the component

#2 2009-10-28 05:03:32

Re: tFileInputMSPositional - How to extract values from the component

#3 2009-10-28 18:54:03

Re: tFileInputMSPositional - How to extract values from the component

#4 2009-10-28 18:55:47

Re: tFileInputMSPositional - How to extract values from the component

#5 2009-10-29 03:06:52

Re: tFileInputMSPositional - How to extract values from the component

#6 2009-10-29 03:20:32

Re: tFileInputMSPositional - How to extract values from the component

#7 2010-07-12 22:30:39

Re: tFileInputMSPositional - How to extract values from the component

#8 2010-07-13 14:51:37

Re: tFileInputMSPositional - How to extract values from the component

Board footer