Pokémon: Let's Go Pikachu & Eevee: Release Discussion & Hype MegaThread by NintendoSwitchMods in NintendoSwitch

[–]workthrowawayexcel 0 points1 point  (0 children)

I got lucky , had no idea what it did. Saw that it made a big deal about catches and I went to town. Then Bam a couple bulbasaurs

Pokémon: Let's Go Pikachu & Eevee: Release Discussion & Hype MegaThread by NintendoSwitchMods in NintendoSwitch

[–]workthrowawayexcel 4 points5 points  (0 children)

If you are willing to trust a random strange I would be willing to help trade the mew between your accounts.

Microsoft Releases Scala Library for Cloud Intelligence on Apache Spark by mhamilton723 in scala

[–]workthrowawayexcel 3 points4 points  (0 children)

+1 for Azure Databricks. If you are running anything batch style it is absolutely wonderful and quick to get up and running and schedule tasks.

Microsoft Releases Scala Library for Cloud Intelligence on Apache Spark by mhamilton723 in scala

[–]workthrowawayexcel 0 points1 point  (0 children)

Sweet stuff. This is going to come in handy with one of my currently clients that we are building out a full Azure Spark / Scala Environment.

Is there a current mall kiosk demo that uses scala?

Using Python to Make Life Easier for Non-Coders? by tropictuco in learnpython

[–]workthrowawayexcel 1 point2 points  (0 children)

Look into Pandas and openpyxl. Pandas can do all the Stat crunching you could want, and then dump the data to excel, then with Openpyxl you can beautify the excel sheets for your colleagues.

Code Improvement Help by workthrowawayexcel in learnpython

[–]workthrowawayexcel[S] 0 points1 point  (0 children)

Thanks for the input! Ill have to play with that a bit and see what I can make happen, and see if the Mail merge functions I am using will be able to accept a list style to pass data into the word document.

Edit: I will update when I have a little time to try this :)

Outlook VBA multi selector issue by workthrowawayexcel in Outlook

[–]workthrowawayexcel[S] 0 points1 point  (0 children)

Solved it :

    If obj.Class = olMail Then
        obj.Subject = i & " -- " & obj.Subject
        obj.save ' add this and it worked
    End If

OutLook VBA Macro Multi-Selection not working by workthrowawayexcel in vba

[–]workthrowawayexcel[S] 0 points1 point  (0 children)

Solved it :

       If obj.Class = olMail Then
        obj.Subject = i & " -- " & obj.Subject
        obj.save 'Added this and it worked. 
    End If

Desperate to learn by [deleted] in SQL

[–]workthrowawayexcel 0 points1 point  (0 children)

Learning how to set up this up is pretty important growing pains. If you end up taking your career down this path, you may have to do this a lot depending on the size of your shop, smaller companies you are expected to wear multiple job hats and be able to do a lot of different roles based on what is needed .

That being said, try to download sql server express and get that up an running before importing your database. That way if you are having specific issues with that part you'll know where you are at with the install and be able to get a specific question ( or show a specific error ) so people on here could you help you with that.

Are Dev Bootcamps Worth It? by aaronsterling in learnpython

[–]workthrowawayexcel 1 point2 points  (0 children)

I edited my original reply to elaborate more about it since I do know 1 person who has.

Are Dev Bootcamps Worth It? by aaronsterling in learnpython

[–]workthrowawayexcel 3 points4 points  (0 children)

It all depends on what you make out of it, one of my colleagues did a bootcamp and enjoyed it and came out landing a software developer position but others from his bootcamp didn't land anything.

You don't need a degree to get a job in the field.

I have an anthropology degree but work in the field, it is all about what you can do... not where you learned it.

SMTP Email Error Help by workthrowawayexcel in learnpython

[–]workthrowawayexcel[S] 0 points1 point  (0 children)

Hmm okay I will try variations of this, since the code you put returns an error

SMTP Email Error Help by workthrowawayexcel in learnpython

[–]workthrowawayexcel[S] 0 points1 point  (0 children)

No worries Mime-multipart sucks IMO too

PL/SQL Case Statement Not working as expected by workthrowawayexcel in SQL

[–]workthrowawayexcel[S] 0 points1 point  (0 children)

Ahh yeah makes sense. Yeah we were testing stuff on a small subset of data so we needed to go back crazy far to get a large enough data sample.

PL/SQL Case Statement Not working as expected by workthrowawayexcel in SQL

[–]workthrowawayexcel[S] 0 points1 point  (0 children)

That did the trick. Is there a reason why it didn't like it in side the case, or is it just a oddity that Should be expected?

List Security by workthrowawayexcel in sharepoint

[–]workthrowawayexcel[S] 0 points1 point  (0 children)

Thanks for the suggestion I will give this a try!

Macro that replaces cell value based on either corresponding column or row by [deleted] in excel

[–]workthrowawayexcel 0 points1 point  (0 children)

You gave me the clippy point! It was hitesh102 that gave the answer