I am currently doing Level 1 Lesson 9 Hands on 1A.
This is Level 1 - Foundation Training - 2018.3 course.
Now the walk-through does not match with the solution provided.
All we need to do is to add two adjacent columns(column A and column B) and store the result in column C.
I have followed the answer given but my solution is partially complete. There are 11 rows and it is adding for 10 rows using For Each loop.
Here is my xaml file.
Main.xaml (11.1 KB)
The issue is with row index
here you go with xaml
level.zip (2.8 KB)
hope would help you
Kindly try this and let know buddy
Write ‘+2’ instead of ‘+1’ and give it a try. If you face any issues then let me know.
rowIndex = inputsTable.Rows.IndexOf(row) + 2
Thanks @Palaniyappan, @lakshman for your help.
However if I give +2 it is not working. Last time it skipped the last row, this time it skips the very first row.
Could you please share that excel file with me. Will check and update you.
Buddy if possible can we have a view on excel a snapshot…
Your excel file does not have column headers but you checked Add headers property in read range activity. Because of that it skipped first row.
buddy uncheck this and run this buddy @sujoy_mukherjee
you were almost done…this was the issue
Thanks buddies @lakshman, @Palaniyappan
It is working now.
Sorry it was my silly mistake to check add headers.
no worries buddy @sujoy_mukherjee
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.