How to make Datatable name dynamic


I have one excel which has 5 Lakh rows. I want to read 50K rows and need to store it in say dt1 Datatable like I need to do loop for 10 times. Issue here I am facing is I am unable to make Datatable name as dyanamic.

Please suggest is it possible or not?

Welcome to the Forum

Give a check if you can work with a List(of DataTable) in your flow

  • with Add to Collection activity the different Datatables are added to the List
  • with yourTableListVar(Index) the particular Table can be accessed

Do not forget to initialize the List with New List(Of DataTable) before using it

Also have a look here:
DTSlice_BySegmentSize_ToTableList.xaml (10.5 KB)