Hello @Rohit Kulkarni ,
Thanks for the ask and using the Microsoft Q&A platform .
As I understand the intention here is to get a query like
Select a,b,c from dbo.company1TablesWithCompany1, if yes please try and use the expression
@{pipeline().parameters.SelectClause}
from @{pipeline().parameters.Schema}.@{pipeline().parameters.Companies[0]}@{pipeline().parameters.TablesWithCompany[0]}
I also suggest that you use the set variable activity to test this kind of query , I have found that to be very helpful . The animation below will make my implementation clear and also how I am using the set variable activity .
Please do let me know how it goes .
Thanks
Himanshu
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members