How to replace empty value with respective of upper row value in datatable

Help Studio
, ,
1

Hi forum,
I have a datatable as:

A spreadsheet displays student data with columns for name, class, gender, roll number, subject, and score; one student named Raj in class 2 has roll number 123 and scores of 40 in both maths and English. (Captioned by AI)
A spreadsheet displays student data with columns for name, class, gender, roll number, subject, and score; one student named Raj in class 2 has roll number 123 and scores of 40 in both maths and English. (Captioned by AI)1920×752 214 KB

As you can see in the above image some fields are empty and I wanted to fill the value with its upper row value as:
The image shows a spreadsheet with columns for name, class, gender, roll number, subject, and score, containing data for a student named Raj who scored 40 in both maths and English. (Captioned by AI)
The image shows a spreadsheet with columns for name, class, gender, roll number, subject, and score, containing data for a student named Raj who scored 40 in both maths and English. (Captioned by AI)1920×548 218 KB

Can anyone tell how to do this.

Thanks in advance

Forum Engagement Daily Reports
2

Hi @Nisha_K21 you want to update values right?

3

@Nisha_K21,

Follow this thread,

5

@ashokkarale The above thread didn’t help me
Is there any other approach for this?

6

Hi @Nisha_K21

Refer the below video

https://youtu.be/pDflFXpxWFE?si=SA7g5R6Oci9tDyFS

Regards,
Gowtham K

7

Hi @Nisha_K21
Use this code in invoke code activity:
datatable as dtInput

For i As Integer = 1 To dtInput.Rows.Count - 1
    For j As Integer = 0 To dtInput.Columns.Count - 1
        If String.IsNullOrEmpty(dtInput.Rows(i)(j).ToString()) Then
            dtInput.Rows(i)(j) = dtInput.Rows(i - 1)(j)
        End If
    Next
Next
1 Like
Forum Engagement Daily Reports
8

This method worked.
Thanks @Manisha_Ravindra

9

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