Hi, I have a DataTable where ColC is blank: ColA ColB ColC ColD 1 Acdd 5678 2 fghh 8900 3 gdhd 4477 I have to convert it to:( Population the entire col with “new”) ColA ColB ColC ColD 1 Acdd new 5678 2 fghh new …

@shrayud - As an alternate if you have more rows and then you want to avoid “For each” - you can try like this…In the “Invoke Code” Activity… dt.AsEnumerable().ToList().ForEach(Sub(row) row(“Test”)= “New”) [image] My Output(I tried to write “New” in my Test Column… [image]

Filling Up Blank Cloumn-DT

Help Studio

shrayud (Shrayus) March 22, 2021, 1:25pm 5

Thanks Prasath, Hiba, Nived. This works fine

2 Likes

Topic		Replies	Views
Fill Data table empty cell with last filled cell in column Activities datatable , database , activities , question	3	835	January 14, 2023
How to create new empty row Help excel , activities , question	6	6005	March 29, 2021
Skip Empty Row in DataTable Studio studio , question , find_references	8	1803	September 26, 2021
How to Remove empty columns in excel using uipath Activities datatable , excel , activities	22	4782	December 4, 2020
How to add zero to empty cells, if the output datatable is dynamic Activities excel , activities , question	10	1929	May 7, 2023

Filling Up Blank Cloumn-DT

Related topics