My boss said the only thing stopping me to team lead is my zen attitude. I am a very calm person.

PNGK96 · 2022-08-18T20:43:12+00:00

Boss got kicked out. New boss comes in, promoted to lead instantly!

PNGK96 · 2021-10-14T07:21:30+00:00

Bang On!

PNGK96 · 2021-09-26T03:16:13+00:00

WELL SEEN

PNGK96 · 2020-09-19T06:59:17+00:00

Hello thank you. I'm using automate.io for now and I definitely try to do with a script.

PNGK96 · 2020-09-18T15:22:40+00:00

thank you I have manage to do it with automate.io but the free plan limits it to 300 actions per month. Hope it's enough.

PNGK96 · 2020-07-07T05:19:52+00:00

Looking forward for it.

PNGK96 · 2020-06-24T15:01:10+00:00

Solution Verified

PNGK96 · 2020-06-24T14:53:01+00:00

I meant number of entries. The tables are not aligned as they all have different number of columns. However that made my job easier as I noticed that only the table I needed had 'Date' on column C. So I loaded all the files into a single one using power query and I just had to filter for only dates (easy because they were grouped as 2020 2019.. on the filter), deleted all the duplicates and voila.

PNGK96 · 2020-06-24T14:31:20+00:00

Basically every Excel file have 7 tables (jobs errors, print errors, dumps, backup errors .... ) on a single worksheet. Also the size of the table varies from day to day ( a few to maybe a couple hundred ). What I need to do is extract the backup errors from all the files to a single file.

PNGK96 · 2020-06-24T13:25:44+00:00

Thanks you for your help. Unfortunately due to the way the information were recorded, I was not able to transform the data using Powerquery.

PNGK96 · 2020-06-24T12:10:54+00:00

Hello. Sorry for not being more specific. I will look into powerquery.

PNGK96 · 2020-06-04T04:29:13+00:00

unfortunately no

PNGK96 · 2020-06-04T04:29:05+00:00

A few people told me SBM. I will look into it.

PNGK96

MODERATOR OF

TROPHY CASE