input csv file have multiple rows and columns. I want to filter particular column and write it to csv/xlsx. First i had done the “Read csv” file and stored into Dt. Then using Build Data Table activity created the first column as City and 2nd column as Count. Now i want filter the City name and update into build dt count column. I had tried the filter data table but i’m able to get only one count in writeline like “DT.rows.count.tostring”. Please advise.
loop the list of unique cities
a) filter datatable (filteredDt) to only get rows where city = current city in loop
b) create new datarow, where City = current city in loop, Count of City = number of rows in filteredDt
c) add new datarow to newDt