How to Transform Data from from one Excel Sheet into another

Help Activities
, ,
1

Good evening everyone,
sorry if I am greedy since Yoichi helped me today with my last problem, but may I ask for help on how would you solve this.
I uploaded Report.xlsx. In it, there are 3 Excel Sheets.
Excel Sheet “ListResetATMDate” is the one that has the raw Data, which I got from the robot: RESET, ATM and DATE. The Date example is from 06.05.2024 to 12.05.2024.
But I don’t know how to filter and group them by ATM or Date to create the OutputListExample1 or OutputListExample2.
I would love to hear from you about how would you achieve the 2 OutputListExample1 or 2(which I created and added manually).
Thank you for any help and advice on how to achieve this.

Please do tell me if more information is needed.

Kind regards,
Report.xlsx (13.1 KB)

2

Hi,

How about the following?

image
image1198×1982 145 KB

Sample
Sample20240527-1.zip (20.4 KB)

Regards,

1 Like
3

You are amazing as always.
Thank you so much, Yoichi.

Huge regards,

4

Hi Yoichi,
Sorry to bother you.
The given code works well in Windows Dependencies.
But it doesn’t work in Windows-Legacy Dependencies. Since I’m getting there an error with Invalid-L-value expression.
L-Error

I read some articles here about that error, but couldn’t find solution.
Is it possible to modify this assign part so that it would also work with Windows-Legacy?

Thank you

5

Hi,

For now, can you try to split the expression, as the following?

strDate = CDate(CurrentRow("DATE")).ToString("yyyy/M/d")

Then

dtNew.Rows(idx)(strDate) = CurrentRow("RESET")

Regards,

1 Like
6

Thank you very much Yoichi. It works.

7

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