Loop through a Directory to read multiple Files

[Former Member]

Hi,

I have a folder, where i will be having multiple files with below file format.

ABC_2015-09-01

ABC_2015-09-02

ABC_2015-09-03

I want to load all these files into a same target .Can you tell me how can do this

[former_member187605 · Accepted solution]

No need for a loop, just use a wildcard for the filename in the source file format, e.g. ABC_2015-09-*.

[Former Member · Accepted solution]

Thanks Dirk, Can i do this using a global variable ??

i will just pass my file format string into the Variable. will that work ?

[Former Member · Accepted solution]

when i try this logic, to pass through parameter, job is failing.

it says cannot open the file

\\sharedpath\ABC_*

[former_member187605 · Accepted solution]

In Source File Editor:

1/. Specify the path in Root Directory.

2/. Put the filename with wildcard (or the global variable with that content) in File Name(s). And don't forget to include the file suffix!!! Chances are high your files are called ABC_*.txt or ABC_*.csv, aren't they?

[Former Member · Accepted solution]

This is working now Dirk. i missed the file extension:(

Thanks for ur help

[Former Member · Accepted solution]

What if I want to load all files from the folder..? irrespective of matching pattern.

-Thanks in advance

Vaishaali

[former_member187605 · Accepted solution]

What about *.*?

[Former Member · Accepted solution]

Perfect..

[Former Member · Accepted solution]

Hello Dirk, Could you please elaborate the options when we drag an IDoc from datastore to designer workspace..?

Thanks in advance.

[prabhu-2020]

Using Multiple flat files (delimited) as source with single file format in Data Services and Data Qu...