Solved: Need to collect Lookup column values into a variab...

Laiq_Rahman · ‎10-31-2024

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?

KNP · ‎10-31-2024

Have you tried using the Set Variable action?

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.

Proud to be a Super User!

View solution in original post

KNP · ‎10-31-2024

Have you tried using the Set Variable action?

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.

Proud to be a Super User!

Laiq_Rahman · ‎10-31-2024

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.

KNP · ‎10-31-2024

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

But have you looked at these settings?

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.

Proud to be a Super User!

Laiq_Rahman · ‎10-31-2024

This is what i am doing

This is the error msg i am getting when i save

KNP · ‎10-31-2024

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

Interim lakehouse maybe?

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.

Proud to be a Super User!