Forum Discussion
Storing Lists in Dataflows
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!
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.
1 Reply
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.