Loop files is what you are looking for. Inside you would put a read csv. Depending on your license, you could easily hit a limit.

Hi @moni,

As mentioned by @hughesfleming68, you have to implement a Read CSV operator inside a Loop Files operator.
Set the path where your files are stored in the parameters of the Loop Files operator.
If you want to store all your files as example sets in your repository, use a Store operator. 
In the parameters of Store operator, set the repository and give the name %{file_name} to the example set. 
In attached file, a general process to perform what you want to do.

Hope this helps,

Regards,

Lionel

What do you expect your final table to look like? Is it one huge table or are you trying to do something else? Can you take three of your 1000 files give an example of what order you need the data?

hughesfleming68 I have 600 data sets that are of the txt type. I want these 600 data to become a dataset in the event, and when I insert them as input in the repository, the output can be as shown below....All 600 dataset is converted into a  file txt  that when I call, a table of 600 is shown to me as shown below.

sara20 
سلام وقت شما هم بخیر من 600 تا دیتاست دارم هر کدوم از دیتا ست های من  یک فایل متنی می باشد من میخوام این 600 تا دیتا ست تبدیل به 

sara20 

sara20 

I need your help to how append file convert to one file Using loop file?

@sara20