I’ve got a JSON to Excel definition working, but I’m stuck at enhancing it. The JSON file is an API response that contains a list of problems; it contains a few “header” fields (# of problems returned for example), then a list of problems. It’s working to the point where I can pull out just the problems and put them to an Excel file, one problem per row. So far that’s good; but the problems can have a list of comments within them. At this point it’s concatenating the four fields relating to the comment (an ID, timestamp of entry, userID who entered it, and comment text), and concatenating multiple comments; that all goes into one “comments” column in the problem’s row. I’d like to refine this a bit; I want to omit the comment ID, I’d like to convert the timestamp to something readable (1629212755561 to 8/17/2021 11:05AM, for example). I’m fine with the timestamp/userID/text concatenated & multiple comments concatenated together in one “comments” cell for that problem’s row.
Any suggestions? I've attached the alteryx definition I'm running and the test JSON data file (had to rename it with .txt so the community would let me attach it)
