Originally posted by: UMBFundServices

Writing my first WTX project.  After some practice and much patience its starting to not only sink in but make sense.  Need the communities help to answer one question.  I have an input file with 12 records but only the first one ends up in the output file.  What property or setting do I need to set to get the full output file?

Thanks!

Scott

Originally posted by: paul.brett

You need to drop to a functional map in a repeating group to consume an input repeating group.

As an example, please review the attached testcase.

Test1 displays the same behaviour you have observed:

"1,This is line one"

Test2 displays the behaviour required:

"1,This is line one
2,and line two
3,and the third line
4,finally we have line four"

Thank-you.

Paul

Follow me on Twitter

Attachment(s)

Repeating.zip   3 KB 1 version

Originally posted by: UMBFundServices

I understand the concept but can't seem to create a functional map for the executable map that I've created.  I've attached a .7z file of the project and the import file if anyone  wants to help me wrap my head around this basic concept (and might be in need of a couple laughs)

Thanks

Scott

Attachment(s)

GreenCentury_MFACT_Import.7z   5 KB 1 version

Originally posted by: paul.brett

No laughing.  We're all beginners at some stage.

The first clue is when your map completes with the warning:

<Message>Input valid but unknown data found</Message>

Your Typetree has been designed to read only 1 row

I will continue to work on this.

Thank-you.

Paul

Follow me on Twitter

Originally posted by: paul.brett

The number of fields on your input Typetree does not match your data.

I have created a simple validation map, and a subset of your input structure (with additional fields - mostly guesswork) to show how to correctly read the input.

Once you are correctly reading the input (including getting the corect row count number) then you can start on your output mapping, using the validation map as a guide.

Thank-you.

Paul

Follow me on Twitter

Attachment(s)

GreenCentury.zip   11 KB 1 version