Talend community forum / READING A COMPLEX STRUCTURED POSITIONAL FILE

dattatray · 2012-07-06 00:23:01

Hello,

I have this scenario to implement. I need to read the file and dump the data in 2 tables one for AccountHeader and the other for AccountDetail. I am having hard time using tFileInputMSPositional component. Can someone help me with this along with how the component works and how it can be used in this scenario.

FILEHEAD 1234
ACTHEAD    AC1 ACB_NAME1
12312312312312312312231 23497293847 2340892340928340 2304902394802384 028934028934
12312312312312312312231 23497293847 2340892340928340 2304902394802384 028934028934
12312312312312312312231 23497293847 2340892340928340 2304902394802384 028934028934
ACTTAIL    AC1 ACB_NAME1
ACTHEAD    AC2 ACB_NAME2
12312312312312312312231 23497293847 2340892340928340 2304902394802384 028934028934
12312312312312312312231 23497293847 2340892340928340 2304902394802384 028934028934
12312312312312312312231 23497293847 2340892340928340 2304902394802384 028934028934
ACTTAIL    AC2 ACB_NAME2
ACTHEAD    AC3 ACB_NAME3
12312312312312312312231 23497293847 2340892340928340 2304902394802384 028934028934
12312312312312312312231 23497293847 2340892340928340 2304902394802384 028934028934
12312312312312312312231 23497293847 2340892340928340 2304902394802384 028934028934
ACTTAIL    AC3 ACB_NAME3

pedro · 2012-07-06 04:13:59

Hi

Welcome to Talend Community!

The component tFileInputMSPositional would work fine.
Please describe the issue you face and show us the structure of these 2 tables.

Regards,
Pedro

dattatray nale · 2012-07-06 16:09:47

thanks!

the tables are

AccountHead
----------------------------------
InputId Identity(1,1) bigint
, AcctCd VARCHAR(10)
, AcctNm VARCHAR(20)

AccountDetail
----------------------
InputId identity(1,1) bigint
, AcctCd varchar(10) -------------- THIS COMES FROM THE PARENT ROW.
, col1 varchar(50)
, col2 varchar(50)
, col3 varchar(50)
, col4 varchar(50)
, col5 varchar(50)

The problem is there is not enough documentation on this component. I am not sure if what i am doing is right. There is no output schema option. And at the moment its giving me the error "The output schema/link named "row" has no column defined, please check it."

I would appreciate if you show me the screen shots of how the options are configured.

dattatray nale · 2012-07-06 16:16:32

dattatray nale wrote:
thanks!

the tables are

AccountHead
----------------------------------
InputId bigint Identity(1,1)
, AcctCd VARCHAR(10)
, AcctNm VARCHAR(20)

AccountDetail
----------------------
InputId bigint identity(1,1)
, AcctCd varchar(10) -------------- THIS COMES FROM THE PARENT ROW.
, col1 varchar(50)
, col2 varchar(50)
, col3 varchar(50)
, col4 varchar(50)
, col5 varchar(50)

The problem is there is not enough documentation on this component. I am not sure if what i am doing is right. There is no output schema option. And at the moment its giving me the error "The output schema/link named "row" has no column defined, please check it."

I would appreciate if you show me the screen shots of how the options are configured.

DATTATRAY NALE · 2012-07-09 19:52:35

inputs on this would be appreciated.. Thanks!

janhess · 2012-07-10 12:32:31

tFileInputMSPositional --> tMap --> tdatabaseOutput

Do this for each table.

Announcement

Unanswered posts

#1 2012-07-06 00:23:01

READING A COMPLEX STRUCTURED POSITIONAL FILE

#2 2012-07-06 04:13:59

Re: READING A COMPLEX STRUCTURED POSITIONAL FILE

#3 2012-07-06 16:09:47

Re: READING A COMPLEX STRUCTURED POSITIONAL FILE

#4 2012-07-06 16:16:32

Re: READING A COMPLEX STRUCTURED POSITIONAL FILE

dattatray nale wrote:

#5 2012-07-09 19:52:35

Re: READING A COMPLEX STRUCTURED POSITIONAL FILE

#6 2012-07-10 12:32:31

Re: READING A COMPLEX STRUCTURED POSITIONAL FILE

Board footer