Hello Yoichi,
Thank you for the quick reply!
I created the index “I”, matched it to the selector like you said
But the Selector Editor won’t accept the input
Removing the “TableCOl=‘1’” doesnt help either.
Plus, how can I get the value from the 6th column, I tried the “Get Row Item” → Column Index 6
Insert it into a Variable “Total” with Int32 as type.
Scraped table below,i hid the true company names.
I think the problem here lies in the first row, as it’s basically an empty row within the table
[Column-0,Column-1,Column-2,Column-3,Column-4,Column-5,Column-6,Column-7,Column-8
,
,NameX,Monthly,28 MAY 2021 02:00,28 MAY 2021 15:30,29,Concept,42,1712
,NameX,Monthly,01 NOV 2016 01:00,01 NOV 2016 12:29,0,Concept,37,1606
,NameX,Monthly,01 JUN 2018 02:00,18 JUN 2018 11:22,0,Concept,34,1677
,NameX,Monthly,04 JUN 2021 02:00,04 JUN 2021 14:52,41,Concept,10,1724
,NameX,Monthly,01 DEC 2017 01:00,21 DEC 2017 11:03,1,Concept,35,1673
,NameX,Monthly,04 JUN 2021 02:00,04 JUN 2021 14:43,8,Concept,31,1723
,NameX,Monthly,04 NOV 2015 01:00,04 NOV 2015 11:12,0,Concept,27,1538
,NameX,Monthly,01 OCT 2016 02:00,07 OCT 2016 11:52,0,Concept,36,1604
,NameX,Monthly,26 JUN 2017 02:00,26 JUN 2017 11:14,3,Concept,41,1656
,NameX,Monthly,04 NOV 2015 01:00,04 NOV 2015 11:19,0,Concept,16,1540
,NameX,Monthly,28 MAR 2017 02:00,28 MAR 2017 09:22,3,Concept,20,1642
,NameX,Monthly,12 JAN 2017 01:00,12 JAN 2017 10:27,3,Concept,38,1635
,NameX,Monthly,20 JUN 2019 02:00,20 JUN 2019 12:52,63,Concept,21,1699
,NameX,Monthly,13 MAR 2017 01:00,13 MAR 2017 11:30,1,Concept,39,1639
,NameX,Monthly,21 MAR 2017 01:00,21 MAR 2017 14:39,4,Concept,23,1640
,NameX,Monthly,04 NOV 2015 01:00,04 NOV 2015 11:33,0,Concept,24,1555
]
I hope you can help with getting the solution, I’m at a loss myself.
My VBA knowlegde isn’t that big either, I basically have to google everything
Thanks in advance!!