Forum Discussion
Query to append data from the same table in 500 Dataverse database instances
Turn the queries you have for the different tables into functions which accept the URL as the parameter.
Take copies, or references, to the table which holds the URLS, one copy or reference per table type. On each of these copies create a new column by calling a custom function and pass in to the function the URL column.
Expand the resulting new column and delete any columns you don't need.
Turn the queries you have for the different tables into functions which accept the URL as the parameter.
Take copies, or references, to the table which holds the URLS, one copy or reference per table type. On each of these copies create a new column by calling a custom function and pass in to the function the URL column.
Expand the resulting new column and delete any columns you don't need.
Thank you! Let me try this and get back.
LE: it works, thanks again.