I’ve got a new request that I believe would be perfect to use with the Loop Dataset activity in TDP, but I’m having some trouble fitting all the pieces together. This is the first time I’ve used this activity, so I’m sure that’s a large part of it.
To summarize: I have a list of values that are returned by a query; I then need to take that list and perform the same action for every value on the list just once. Right now the list has 23 items and the action in question is to export the results of a query to Excel, using the value from the list as part of the query.
Seems like it should be fairly simple.
However, when I built a small test, and used the Log Comment activity as my action to perform, with the value of the dataset variable as the output, I got the same value 23 times in the log, instead of each unique value. It seems as though it’s not moving through the list and resetting the value for each loop, and I’m sure it has to do with something I’ve failed to configure correctly.
Does anyone have any insight on doing something like this?