Passing Array Parameter in Look Activity

Question

Hello Team,

I want to Pass the array parameter in lookup activity.

I am Passing the parameter :

AND LEFT(t.TABLE_NAME,CHARINDEX('$',t.TABLE_NAME) - 1) IN [@{pipeline().parameters.Companies}]

After running the query i am getting error

Please advise .

Thanks
RK

Answer 1

Hey Rohit,
Based on above things I guess your requirement is you want to get the result from Information_schema:
So please make the below changes :
Update the Parameter type to String and its value as :
'Group','ABC'
without any parenthesis

And also update lookup activity as below:
select * from from INFORMATION_SCHEMA.TABLES t

where LEFT(t.TABLE_NAME,CHARINDEX('$',t.TABLE_NAME) - 1) IN (@{pipeline().parameters.Array})

Hope that should solve

Answer 2

And even tried
@{pipeline().parameters.Companies}

Answer 3

this is the correct one:

@markus.bohland@hotmail.de ('select * from INFORMATION_SCHEMA.TABLES t
where LEFT(t.TABLE_NAME,CHARINDEX(','''$''',',t.TABLE_NAME) - 1) IN (', replace(replace(replace(replace(string(pipeline().parameters.Companies),'[',''),']',''),'\',''),'"','''') ,')')

don't use @ within another @

Answer 4

Please refer the screenshot for error :

Answer 5

Sorry again i am getting error.I am not able to find exactly the where is missing comma the error is :