Hi ,
I have 2 sheets which have one value in common i.e. plant value
We have to check if plant values are present in 2nd sheet We need to change value from 2nd column who’s name is the date i.e. 1/8/2024
We need to paste the values divided by 100 in decimal format.
We need to change the value of that column in Rate column.
I have attached the 2 files test.xlsx and Rate.xlsx.
Test.xlsx is the master sheet and Rate.xlsx is the sheet that needs to be changed.
Test.xlsx (8.7 KB)
Rate.xlsx (9.3 KB)
Can anyone help me with the solution?
@supermanPunch @Gokul001 @ushu @kirankumar.mahanthi1 @Palaniyappan @Sudharsan_Ka @Anil_G
Can you suggest how can we solve the issue please?
Hi @Anil_G
Did you find anything for these?
- Read both rate and test file into dt1 and dt2 respectively
- Now use a for loop on
dt1.Columnsand add a index variable index property in for loop - Inside loop use if condition with
Not index=0 - on else side use filter table on dt2 and filter column 0 with
currentItem.ColumnName - if filtereddt.Count>0 on then side use assign as below
dt1.Rows(0)(currentItem.ColumnName) = filtereddt.Rows(1)(1)
cheers
Hi @Anil_G
Can you help me with the workflow if possible.
Because I am getting a bit confused with the flow I need to add.
Thanks in advance.
Hi @Anil_G
We have to update the value in Rate sheet Rate column as per plant numbers .
Means if the value for 1504 is 0.89 it has to be placed in the rate sheet under 1504 same if 1575 has value 0.98 it has to be placed under 1575 only.
Cheers
The same is happening…writing to excel is somethign that I did not add…please add those steps…logic remains same
cheers
Thanks for the solution @Anil_G
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.