locked
V2 - Cross join values in two arrays to create new array RRS feed

  • Question

  • I want to cross join values in two arrays and use in a foreach activity to query a database. You aren't allowed to nest foreach activities and even if you were I didn't find a way to reference the item in the outer foreach.

    Any ideas on the best way to do this? I would like to make two lookups and then cross join the results with som extra text and then iterate over the resulting array.

    The question is about Data Factory V2.

    Thursday, March 15, 2018 10:29 AM

Answers

  • Didn't find any function to do this. Ended up creatimg another pipeline and passed in the first array as @item() and the second array in its whole in a foreach activity containing an execute pipeline activity. Then you can iterate the second array in each instance of the second pipeline and combine the values.
    • Marked as answer by Molotch Thursday, March 15, 2018 7:54 PM
    Thursday, March 15, 2018 7:53 PM