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
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.
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…
The issue should be handled by replacing
However if you could provide the sample excel which gives out error, we could confirm if that is the correct approach to be taken.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.