Everyone here is so helpful, but I wonder if anyone can help with this.
I have the following data, and want it in a nice clean table
| { |
| "value": [ |
| { |
| "type": "AssignmentCardLearning", |
| "user_id": 112913, |
| "external_user_id": "vwr@company.com", |
| "external_email": "vwr@company.com", |
| "plp_id": 1807, |
| "external_plp_id": null, |
| "module_id": 4545, |
| "external_context_id": "", |
| "class_id": 12503, |
| "external_assignment_id": "", |
| "assignment_id": 31972, |
| "progress": 0, |
| "completion_date": null |
| }, |
| { |
| "type": "AssignmentCardLearning", |
| "user_id": 112913, |
| "external_user_id": "vwr@company.com", |
| "external_email": "vwr@company.com", |
| "plp_id": 1807, |
| "external_plp_id": null, |
| "module_id": 4555, |
| "external_context_id": "", |
| "class_id": 12503, |
| "external_assignment_id": "", |
| "assignment_id": 31972, |
| "progress": 0, |
| "completion_date": null |
| }, |
| { |
| "type": "AssignmentCardLearning", |
| "user_id": 112913, |
| "external_user_id": "xyz@company.com", |
| "external_email": "xyz@company.com", |
| "plp_id": 1807, |
| "external_plp_id": stuff, |
| "module_id": 4612, |
| "external_context_id": "", |
| "class_id": 12503, |
| "external_assignment_id": "", |
| "assignment_id": 31972, |
| "progress": 0.14, |
| "completion_date": null |
| } |
| ], |
| "paging": { |
| "next_page": "/api/v1/eud/outcome?eud-id=1234etc"" |
| }, |
| "transaction_id": 166530 |
How could I use Alteryx to output it like the following:
| type | user_id | external_user_id | external_email | plp_id | external_plp_id | module_id | external_context_id | class_id | external_assignment_id | assignment_id | progress | completion_date |
| AssignmentCardLearning | 112913 | vwr@company.com | vwr@company.com | 1807 | null | 4545 | | 12503 | | 31972 | 0 | null |
| AssignmentCardLearning | 112913 | vwr@company.com | vwr@company.com | 1807 | null | 4555 | | 12503 | | 31972 | 0 | null |
| AssignmentCardLearning | 112914 | xyz@company.com | xyz@company.com | 1807 | stuff | 4612 | | 12503 | | 31972 | 0.14 | null |
