Build Datatables using the Strings in a array whose length is dynamic

Hi. I need to build the Data tables using the String names present in a Dynamic array. Please help me.

Hi @Konda_Sai_Charan_Goud ,

Please follow the below steps to achieve your requirement.

  1. Use your dynamic array and assign to string array.

  2. Use For each loop to each and every column value mentioned in the string array dynamically one by one.

  3. Use Add data column Assign column name as item.tostring and assign empty data table (use data table variable assign default value new Data table so it creates empty data table)

  4. After for each loop ends it creates datatable with the the columns you available in the dynamic array.

i hope the above steps might helpful to your requirement. please review the attached work flow for your reference. thanks.

DynamicDatatableCreation.xaml (7.4 KB)

Hi,

If there is no special character in your column name, we can use Generate DataTable activity as the following.

Regards,

1 Like