Form(s) data from web portal is being collected into a dynamo DB as key:value pairs.
Form Question : Form Response.
Different forms have a different number of key: value pairs. Forms of the same type have the same number of responses.
Require a Spotfire analysis that can for a selected form, extract and pivot the Keys to columns and insert the values into the columns.
Output needs to be a column for each key, populated in all the values.