Storing Lists in Dataflows

[PANDAmonium]

Hi All,

I'm trying to store lists within records in a dataflow, but each time I save and close, it autogenerates steps "Transform columns" changing the type to text which produces and error then the step "Replace error" turning them null. I making a summary of events by date, so it looks something like:

Date          | Count A | Count B | Count C | Set A   | Set B |  Set C 

1/23/2020 |  123       | 456        | 789        | [List]    | [List]  |  [List]

I know I can expand them on Date and maybe move them into individual tables, but I like how much cleaner this looks plus I want to know for future reference and to get better at this.

Thank you!

[PANDAmonium · Accepted solution]

Figured out a workaround. I don't have that many Id's in each set moving daily, so I expanded the lists into a string. Then after the data is pulled in we can convert it back to a list if needed.

If you do know how to store values as lists within a dataflow, please let me know still for future reference. Seems like something that should be possible. Thanks.