Excel Data Consolidation

[tom.ri]

Hi All,

in the course “Excel data consolidation” it says that one should “Reference as” a excel as “MonthReport” 3 times. One cannot reference to a variabel 3 times though. Hence, there is an error:

Could you help me please?

UiPath Academy

[Gautham_Pattabiraman]

Hi @tom.ri ,

I could see you have used the variable name as MonthReportSales.

You need to use the same reference throughout can you try and tell if issue persists.?

[ashokkarale]

@tom.ri,

The error is saying that you cannot use MonthReportSales as Reference as because your workflow have a variable declared with same name.

Solution:
Try Reference as something other than MonthReportSales. You can use MonthReportSalesExcel

Thanks,
Ashok

[tom.ri]

@ashokkarale Thanks for your response. That´s correct. I named it differently, but in the UiPath instruction video they use the same variable three times. Could this be due to an old version of Studio in the video?

[Ramya_25 (Ramya N)]

Based on the scope it differs. We have to check based on our requirement. Its advisable to use different variable names

[ashokkarale]

@tom.ri,

It would have used in same context or datatype like this. This will not change despite version changes.

If still not satisfied, please share screenshot of the video as I’m unable to access the video directly.

Thanks,
Ashok

[Shashidhar_Telugu]

variable name you created is MonthReportSales. but you have use monthreport. Please check and verify