DSXchange

HI Guys,

I have multiple files in a location. Now i need to process each file one after the another.

So, i need to pass the file names one after the another to a sequence.

Can you guys help me with this.

Cheers!!!!

Get all the file names through execute command stage. Use loop stage to process all files one by one by sending the file names.

What have you tried? That's exactly what the Start/End Loop stages are for, all you need to do is build them a delimited list of the filenames first.

I created a Execute command stage with "ls /path/Text*.txt" command in it.
Now How to pass it to the Start Loop Activity stage?

That by itself won't work as the list needs to be delimited. Typically you would use a User Variables Activity stage to generate the list and your O/S should have an "m" option (off the top of my head) to return your list of filenames comma delimited.

Is the order in which files were created in the directory important ?

one possible option is to use And in an user variable stage use

Trailing field marks from command output need to be removed or else they can create problems.. use this variable in the start loop , specifying comma as the delimiter.


Disclaimer : Some commands may not behave the same way in all platforms. Use discretion