Originally posted by: DenisBE

Hello,

I receive in a directory different files.

My questions :
How to create a reference file (XSLT, table, file ...?) That would include a "MessageName" (key) column and a "directory" column ?

Regard's

Denis.

Originally posted by: Bragger

You can create a reference file and store it somewhere on server. Now your WTX map will have 2 input cards - First one will read input file and second will be this reference file. Now on output side, create a group consisting of (s) field like this - Group (s) - Field. Create a functional map for each record in input file and pass entire reference file along with it. Inside the functional map, you can try something like this - PUT ("FILE", LOOKUP(<Directory Name from reference file>, Message Name from Input file = Message Name from Reference File), PACKAGE(Input Record)). 

I hope this helps.

Originally posted by: PaulBrett

Please find an example attached.

Thank you.

Paul

Follow me on Twitter

Attachment(s)

SortFiles.zip   4 KB 1 version