Page 1 of 1

Complex Flat File using wildcards

Posted: Fri Jul 06, 2012 9:12 am
by IDC
Hi all,
i'm using Complex Flat File stage to read from different .txt file so i set:

- In CFF stage
-- file type "File pattern"
-- file name(s) "C:\bla\bla\file_*.txt"

- In Environment variable
-- $APT_IMPORT_PATTERN_USES_FILESET = True

The job runs correctly but i need something that works like "file_name_column" option in Sequential file stage.

How can i get this functionality ?

Thanks Everybody for the help.

Posted: Fri Sep 07, 2012 8:33 am
by synsog
Dear Experts, request you please provide your valuable inputs on the same . We have have a similar requirement like "IDC".

Thanks for your help and support in advance.

Posted: Fri Sep 07, 2012 9:28 am
by chulett
I do not believe that has ever been supported in the CFF stage. If true, as a workaround you could look into a looping Sequence job that calls the CFF job once per file found, passing in the filename to process as a parameter.