API Data Retrieval Workflow (ETL)

[#1]

This workflow shows the Extract, Transform, and Load (ETL) process. This workflow extracts data from Data.gov  via an API connection and transforms the data from a JavaScript Object Notation (JSON) format into a tabular format that is loaded to Excel. Similarly, the output of this workflow can be ingested into a SQL database or any other tabular-friendly data storage system.

[RWvanLeeuwen]

Hi @HugoMichael02 

Thanks for sharing your work
[redacted, and edited as requested by Hugo]

 (and for handling my constructive feedback)  :-)

I've shared how to handle the remaining conversion errors through our chat

P.S.: no I cannot delete this message, nor can I disallow others to post on this public platform.

[tmoore1210]

Hey @HugoMichael02 ! My name is Trenton Moore; my project partner Chiemerie Ike-Njoku and I are students at Fisk University. We are currently taking a Data Visualization course, and we are interested in creating a project inspired by yours. We're new to Alteryx and eager to learn. Would you happen to have any advice or tips on how to start?

[RWvanLeeuwen]

Hi @tmoore1210 
Did you know you can connect to an Alteryx Mentor through this comunity page: https://community.alteryx.com/t5/Alter-Nation/You-re-Invited-Join-Alteryx-Mentor-Connect/ba-p/123028...

Have a great day!