Is it possible to create a separate datatable for each csv file in folder

Help Studio
6

Create Dictionary (Of String, Datatable)

image
image1245×29 3.09 KB

For Each in DirectoryInfo (see here: Using DirectoryInfo.GetFiles instead of Directory.GetFiles, advanced filtering)
– Read CSV into yourDict(currentItem.Name)

image

Then you’ll have a dictionary of datatables. The key will be the filename. So to get to the datatable for a particular filename you reference yourDict(“filename”). You can use that expression anywhere you’d use a normal datatable variable.