question

RohitKulkarni-3496 avatar image
0 Votes"
RohitKulkarni-3496 asked RohitKulkarni-3496 commented

Pipeline Issue

And passing the condition in where clause :

RIGHT(t.TABLE_NAME,LEN(t.TABLE_NAME) -CHARINDEX('$',t.TABLE_NAME)) IN ('@{ if(lessOrEquals(length(pipeline().parameters.TablesWithCompany),1), join(pipeline().parameters.TablesWithCompany,''), concat(join(pipeline().parameters.TablesWithCompany,''',''')) )}')


But in parameter passing: Folder :@{pipeline().parameters.RawFolder}/@{pipeline().parameters.Companies[0]}/Tables/@{pipeline().parameters.TablesWithCompany[1]}

I am passing @{pipeline().parameters.TablesWithCompany[1]} 1 or 0 .

I am getting issue :

error :The expression 'pipeline().parameters.TablesWithCompany[0]' cannot be evaluated because property '0' cannot be selected. Property selection is not supported on values of type 'String'.
Please advise
Thanks in advance
RK

azure-data-factory
· 4
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MartinJaffer-MSFT avatar image MartinJaffer-MSFT ·

Hello @RohitKulkarni-3496 and welcome to Microsoft Q&A.

Can you please tell me what data type the parameter "TablesWithCompant" is? Is it String or Array? A conversion may be needed, either in the expression, or the data type.

0 Votes 0 ·
RohitKulkarni-3496 avatar image RohitKulkarni-3496 MartinJaffer-MSFT ·

It is array and converted Now it is working fine.

Thanks for your prompt response MartinJaffer

0 Votes 0 ·
MartinJaffer-MSFT avatar image MartinJaffer-MSFT RohitKulkarni-3496 ·

Thank you for letting me know, @RohitKulkarni-3496 . I found another question of yours, which looks related.
https://docs.microsoft.com/en-us/answers/questions/321095/index.html
Do you still need help with that one?

0 Votes 0 ·
RohitKulkarni-3496 avatar image RohitKulkarni-3496 MartinJaffer-MSFT ·

In copy data activty when i run this query :
Select *
from @{pipeline().parameters.Schema}.
[@{pipeline().parameters.Companies[0]}$@{pipeline().parameters.TablesWithCompany[0]}]

it is working fine.
But this a child pipeline. When i execute the parent pipeline it will execute other activity and will come and fail in this copy data activty and gives me this error :


The expression 'pipeline().parameters.Companies[0]' cannot be evaluated because property '0' cannot be selected. Property selection is not supported on values of type 'String'.

Please advise me ASAP.

Since from long time i am facing this issue and need to get it completed ASAP.

Regards
RK

0 Votes 0 ·

0 Answers