UiPath Level 1 Lesson 9 Hands On 1A

Learning Hub Academy Feedback
1

Hello friends,

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)

1 Like
2

Buddy @sujoy_mukherjee
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
Cheerss @sujoy_mukherjee

3

@sujoy_mukherjee

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

4

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.

2 Likes
5

@sujoy_mukherjee

Could you please share that excel file with me. Will check and update you.

6

Buddy if possible can we have a view on excel a snapshot…
Cheers @sujoy_mukherjee

7

Sample_Columns[1].xlsx (8.5 KB)

Hi @Palaniyappan, @lakshman here is the file

1 Like
8

@sujoy_mukherjee

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.

1 Like
9

buddy uncheck this and run this buddy @sujoy_mukherjee
you were almost done…this was the issue

image

2 Likes
10

Thanks buddies @lakshman, @Palaniyappan
It is working now.
Sorry it was my silly mistake to check add headers. :slightly_smiling_face:

2 Likes
11

no worries buddy @sujoy_mukherjee
Cheers
keep going

1 Like
12

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