Forum Discussion

audrianna21's avatar
audrianna21
Frequent Visitor
2 years ago
Solved

Dataflow Gen2 Lookup Activity - Get First Row Only

I am currently attempting to get 1 record out of a delta lake table in my lakehouse. When configuring the lookup activity there is a selection to First Row Only. I do want only 1 row, but I need a wa...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi audrianna21 ,

    To filter the data where "Running Process = Bob3", you will need to use a query within the Lookup Activity. In the settings for the Lookup Activity, specify your query in the 'Query' field to filter the data. For example:

    SELECT * FROM your_table WHERE RunningProcess = 'Bob3'

    Replace your_table with the actual name of your table. This will ensure that the Lookup Activity only retrieves records where the Running Process is equal to 'Bob3'.

    Selecting the First Row: Once you have filtered the data, the "First row only" checkbox will ensure that only the first row of the filtered result set is returned. Make sure this checkbox is selected in the Lookup Activity settings.

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi audrianna21 ,

To filter the data where "Running Process = Bob3", you will need to use a query within the Lookup Activity. In the settings for the Lookup Activity, specify your query in the 'Query' field to filter the data. For example:

SELECT * FROM your_table WHERE RunningProcess = 'Bob3'

Replace your_table with the actual name of your table. This will ensure that the Lookup Activity only retrieves records where the Running Process is equal to 'Bob3'.

Selecting the First Row: Once you have filtered the data, the "First row only" checkbox will ensure that only the first row of the filtered result set is returned. Make sure this checkbox is selected in the Lookup Activity settings.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • audrianna21's avatar
    audrianna21
    Frequent Visitor
    2 years ago

    Hi Anonymous,

     

    To ensure I'm looking at this correctly, I can only see the Use Query option if I'm using a Data store type of External and then connect to my delta table in my lakehouse through the SQL endpoint, yes?

     

    Right now I can't use a query if I select a Data store type as Workspace and then Workspace data store type Lakehouse?

  • GammaRamma's avatar
    GammaRamma
    Helper I
    2 years ago

    I have the same problem and this doesn't solve it. If you read the original question, audrianna21 wants to query a lakehouse table. There is no query option for a lakehouse source like there is for other sources :

    So how can we get a specific line from a lakehouse table from inside a pipeline?
    Thanks