Hi,
I developing Web ui automation in dax. now i want to change dax table particular column value is 0.
Regards,
I have one table in dax . change particular column all value change to 0
Regards,
Is the data stored in a DataTable variable? @MD_Farhan1
Do you want to change the data there itself or else do you want to use the changed data for further process?
Regards
You can do it by using For Each Ui Element activity. Inside it use Type into activity to update column value to 0.
Another approach would be, get table data with table extraction and then iterate through For each row in datatable.
Get the selector for the particular column and make it dynamic to each row.
use type into to update it to 0.
Thanks,
Ashok 
no. that table in my web ui . every cell is editable.
Regards,
give me some sample screen shot. that one is use full for me.
Thanks & Regards,
HI @MD_Farhan1
You can use For Each Ui Element activity and indicate the column which you wanted to edit. Select the first row of that column and the entire column will be selected.
Use the type into within the For Each Ui Element activity and give it as 0.
Regards
1 Like
Hi @MD_Farhan1
If you are automating in excel then please use the For Each Excel Row activity. Because the For Each UiElement activity is restricted to the Web Applications.
Regards
in for each ui element not select particular column . it select whole table . but flow is not working. i think that one is grid type
Hi @MD_Farhan1
Select the Element present in the first row in that column
For example the column you wanted to change the value is present in H column, then select the H1 and it will help in extracting the entire column.
Regards
Not working bro give me some other way. if i click the cell value . some cell is not select . type into activity try to type 0 in a header only.
Regards
1 Like
Happy Automation !! @MD_Farhan1
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.