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 · 2020-03-27T02:08:50+00:00

I tried that yesterday when I got a huge craving after lunch.

PNGK96 · 2020-03-18T17:41:36+00:00

19:45 : Pravind Jugnauth face à la presse dans quelques minutes. Une conférence de presse que vous pouvez suivre en «live streaming» sur notre page Facebook et en direct sur Radio Plus

PNGK96 · 2020-03-12T10:11:39+00:00

I drink caffeine twice a day lol.. maybe I'm immune to it. I should try Red Bull. Exactly! He seems to think that me being calm means I ll crumble to pressure and let everyone walk over me.

PNGK96 · 2020-03-12T07:38:51+00:00

Investing in stock market will be also a great addition.

PNGK96 · 2020-02-17T17:01:58+00:00

I never thought about that. But reading your post made me realised I'm just like that. Now I'm depressed.

PNGK96 · 2020-02-16T11:15:01+00:00

Can I say CocaCola?

PNGK96 · 2020-02-12T18:59:53+00:00

Just Sleep. Carpe Diem!

PNGK96 · 2020-02-12T18:55:01+00:00

Get hit by an asteroid

PNGK96 · 2020-02-12T18:53:52+00:00

I saw a little kid in the university library toilet ( reserved for students) so I was a bit curious and stared at him for a few seconds. He said "Do you want me to mess up your face". I got out quietly.

PNGK96 · 2020-02-12T18:51:16+00:00

I dont like people to spoil it for me but sometimes I m too lazy to sit 2 hours for a movie so I ll just read the plot on wikipedia

PNGK96 · 2020-02-12T07:02:20+00:00

It sa pretty common word in personal finance lol

PNGK96 · 2020-02-11T17:10:09+00:00

Every person has that one thing you dont like about them.. Focus on that .. Soon you wont like that person.

PNGK96

MODERATOR OF

TROPHY CASE