topic Re: Need to collect Lookup column values into a variable in Pipelines

Need to collect Lookup column values into a variable

Laiq_Rahman — Thu, 31 Oct 2024 22:57:37 GMT

Hi,

I am trying myself familiar with microsoft fabric. I am using lookup activity to collect a column records into a variable as array. For eg: If a column "Fruit" has orange, apple etc, Then my variable activity should collect those information. Can i get help on this?

Re: Need to collect Lookup column values into a variable

KNP — Fri, 01 Nov 2024 01:14:54 GMT

Have you tried using the Set Variable action?

Re: Need to collect Lookup column values into a variable

Laiq_Rahman — Fri, 01 Nov 2024 03:49:22 GMT

Yes.. it's working. thank you. I'm stuck with another issue. It's suggest copy data activity is only possible through enable staging => External but not sure how to configure. We don't have blob or azuredatalake gen2.

Re: Need to collect Lookup column values into a variable

KNP — Fri, 01 Nov 2024 04:00:11 GMT

I'm not sure as I usually go to a Lakehouse, so not necessary.

But have you looked at these settings?

Re: Need to collect Lookup column values into a variable

Laiq_Rahman — Fri, 01 Nov 2024 04:27:04 GMT

This is what i am doing

This is the error msg i am getting when i save

Re: Need to collect Lookup column values into a variable

KNP — Fri, 01 Nov 2024 06:00:59 GMT

Sorry I'm not sure how else to get around this.

Interim lakehouse maybe?