Replace blank value in datable with NA

Neha_Aggarwal1 · January 31, 2023, 2:14pm

@Sudharsan_Ka if u see in the immediate there is Comment column name but its throwing error

Sudharsan_Ka · January 31, 2023, 2:48pm

What datatable are you looping @Neha_Aggarwal1 ?

Neha_Aggarwal1 · January 31, 2023, 2:56pm

@Sudharsan_Ka solved i have added one more condition in if

its working now

Neha_Aggarwal1 · February 1, 2023, 9:47am

@Sudharsan_Ka if i want to implement this condition for every column present in excel so what i need to change .

ppr · February 1, 2023, 9:54am

like this:

system · February 4, 2023, 9:55am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
LINQ query to update(replace)datatable in uipath Help datatable , excel , activities , question	8	17361	December 8, 2019
Replace Null or empty values with static value in a datable which has mutiple columns StudioX studiox , question	6	176	December 7, 2023
Replace specific values(Nà) of all columns of datatable - Reopen Studio datatable , excel , studio , question , data_manipulation , activities_panel , linq , linq-query , linq-loop	16	601	September 8, 2023
Replace Excel Cell value Studio studio , question , extension	2	1168	September 27, 2021
How to replace null value to 0 in a datatable without check cell by cell Help datatable	3	4995	September 14, 2020