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 |
Solved! Go to Solution.
amazing!
User | Count |
---|---|
56 | |
27 | |
25 | |
23 | |
21 |