Append all data from table which has one specific value to it's own data table

datatable
uiautomation
studio

#1

I have a data table with 8 or so attributes. There is one attribute in particular which I need to copy all rows where that unique value is the same into a new data table. (ex: if one of the attributes is customer name, I need to create a new data table for each customer to have ALL rows of data that contain their name). The attribute is dynamic so I can’t just filter by specific names. I’m having trouble determining the most efficient way for the bot to loop through the attribute to pull out each unique value and assign it to a new table. Please let me know if you have any ideas!


#2

I’m not sure if this is what you are looking for. What I did was to iterate through the rows of the data table and add each new customer name to a collection. While iterating, if the collection of names doesn’t contain the customer name from the current row, then filter by that name and put the results in a new data table; if the collection contains the customer name, do nothing and move on to the next iteration. Here’s an example: Main.xaml (15.8 KB)

Hope this helps.