Check the Value in Datatable if Value is Available write the Corresponding Row


I have Excel sheet in that sheet some cell are empty in that cell fill the values. i have the check the valuse is previous presented in that cell based on corresponding cell or group of values.

i will show you small example.

i get Input.

Input.xlsx (8.0 KB)

(Highlight Cells to be filled automatically)

i Expected Output.
Output.xlsx (7.8 KB)


Hi @Shyam_Pragash ,

We can Update the values by understanding what are the Key values that need to be matched. From the data that you have provided, the ZSM Number and ASM Number maps to one entity or rather can be said that they should have either a ZSM Number or ASM Number.

By taking the above point into consideration, I have developed a workflow, which is giving the expected output, but would like you test with different sample test data as well.

Check the below workflow :
Update_MissingValues_DT.xaml (10.8 KB)

Let us know what is the outcome after testing.

Hi @supermanPunch

Working fine…

Incase no data in the corresponding cell that time i am getting error…
Just leave as it empty cell… if data is avaliable that time only has to fill other leave it as blank.

How to over come this issue…


@Shyam_Pragash ,

The issue should be handled by replacing .First with .FirstOrDefault.

However if you could provide the sample excel which gives out error, we could confirm if that is the correct approach to be taken.

Hi @supermanPunch

Thank You. ):


1 Like

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