Cloud Quest #7: Marvel-ous Comics

[OllieClarke]

Here's my solution:

Spoiler

[phottovy]

Attached in my solution. Also, I noticed something unexpected when trying to debug my original logic. I initially made a mistake in my logic and tried to compare my result to the provided solution. When I attempted to join on the Character and Published year columns, the null values in the Published year column did not join together. I posted a more detailed write-up here: Unable to join on null values 

Spoiler

[mshishido]

a little bit different, but could get almost the same result

[ggruccio]

Slight detour while I fixed something that worked in Regex for the majority of records - 😀

Spoiler

[thomasduong]

Here is my solution for CQ7. Btw, I was having trouble loading the comics.csv file in the input tool. I changed the encoding which helped fixing the issue.

[patrick_digan]

Spoiler

[SGolnik]

another one done

[smurfitt]

Please find attached my solution, some slight differences in the order of the records as I prefer them sorted on issue number ;-) 

I did have some issues with the data for the Comics csv loading correctly,  it would load, but then it would not render the results in the tool anchors,  Not sure if that was expected, but did eventually get it to work by uploading the file into the datasets rather than via the workflow dialog.

[Carolyn]

---

@smurfitt wrote:

Please find attached my solution, some slight differences in the order of the records as I prefer them sorted on issue number ;-) 

I did have some issues with the data for the Comics csv loading correctly,  it would load, but then it would not render the results in the tool anchors,  Not sure if that was expected, but did eventually get it to work by uploading the file into the datasets rather than via the workflow dialog.

---

 Argh, that's where I'm stuck right now. I tried both uploading the file into the dataset and the workflow dialog but no luck on either :-/ 

[Carolyn]

Solved!

I had a lot of trouble getting the comics.csv file to work. It would upload but then wouldn't pull into the workflow. I ended up deleting all the "#" and the Description column and one of those fixed the issue. FYI @AYXAcademy 

Spoiler