Set variable from lookup activity result

Question

Hi,

I have a lookup activity in and ADF pipeline connected to a set variable activity:

The query in lookup activity is:

Select name from [dbo].[someTable] where [ID] = '@{pipeline().parameters.pl_ID}'  

name is actually an integer

The idea is to query the database, set a variable already_exisiting_name equals to the result from the query

I have a variable current_name, if the alread_exsiting_name is equal to current_name then pipelines fails otherwise if already_exisitng_name is empty (as in this case, when there is no data yet in the db) the pipeline continues or if already_exisitng_name is smaller than current_name the pipeline continues.

When Iexecute the lookup activity, and examine the output, I dnt see any name field:

Answer 1

Hey,
In case of lookup activity in case if there is no data in your output below are the 2 ways output is visible:

1. Disabling first row only
   

2) Enabling 1st row only

Based on your scenario, there might be cases wherein there might be no data or some data, so I would suggest disable the 1st row only property and have a below logic:
IF count=0 meaning no data , so default assign your variable a value else pick up the 1st row value of the column