Error I can't get rid of : tFileInputMSPositional_1("header",,"1,3",false,true);

Highlighted
Six Stars

Error I can't get rid of : tFileInputMSPositional_1("header",,"1,3",false,true);

I have and error I can't get rid of:  tFileInputMSPositional_1("header",,"1,3",false,true);

I found it in the code and I'm afraid it may be a bug.  Below is the simple package I've designed.

I need to test importing a Multiple Schema File like this:

H12345FOO

D12TRAIN1499

Where H is the header and D is the detail row.  Example would be a transaction # 12345 Customer FOO,

bought 12 Trains for 14.99.  There could be multiple transactions in each file so you would see several H and D's.

No matter how simple I make the file I keep getting the same error.  Any ideas?

Talend is saying that one of the commas is wrong, however you can't edit the code so I'm at a loss.

("header",,"1,3",false,true)  

 

 

Capture.JPG


Accepted Solutions
Highlighted
Sixteen Stars
Sixteen Stars

Re: Error I can't get rid of : tFileInputMSPositional_1("header",,"1,3",false,true);

Great!
If the solution I proposed matches with what you expect, thank's to accept it and mark your case as solved.

TRF

View solution in original post


All Replies
Highlighted
Sixteen Stars
Sixteen Stars

Re: Error I can't get rid of : tFileInputMSPositional_1("header",,"1,3",false,true);

For header, pattern should be "1,5,3".
For details, it should be "1,2,5,4".
Don't forget that all records of the same type must match the same pattern.

TRF
Highlighted
Six Stars

Re: Error I can't get rid of : tFileInputMSPositional_1("header",,"1,3",false,true);

I got it. The example I was using from a tutorial was flawed. The developer left out the Header value, which goes between those two commas. Only took a few hours of staring at it and finally asking a question on here, until it clicked.
Highlighted
Sixteen Stars
Sixteen Stars

Re: Error I can't get rid of : tFileInputMSPositional_1("header",,"1,3",false,true);

Great!
If the solution I proposed matches with what you expect, thank's to accept it and mark your case as solved.

TRF

View solution in original post

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog