Forum Discussion

Laiq_Rahman's avatar
Laiq_Rahman
Icon for Helper I rankHelper I
1 year ago
Solved

Need to collect Lookup column values into a variable

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 ...
Pipeline
  • KNP's avatar
    KNP
    1 year ago

    Have you tried using the Set Variable action?

     

     

KNP's avatar
KNP
Icon for Super User rankSuper User
1 year ago

Have you tried using the Set Variable action?

 

 

Laiq_Rahman's avatar
Laiq_Rahman
Icon for Helper I rankHelper I
1 year ago

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's avatar
    KNP
    Icon for Super User rankSuper User
    1 year ago

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

    But have you looked at these settings?

     

     

    • Laiq_Rahman's avatar
      Laiq_Rahman
      Icon for Helper I rankHelper I
      1 year ago

      This is what i am doing

       

      This is the error msg i am getting when i save 

       

      • KNP's avatar
        KNP
        Icon for Super User rankSuper User
        1 year ago

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

        Interim lakehouse maybe?