Forum Discussion
Skilled SharerHow can I apply a function to an activity result (a list)?
I have a simple data Pipeline as follows:
get_data_list activity returns a list of rows of a table. So, to access output data I should:
@activity('get_data_list').output[0].filed1
@activity('get_data_list').output[5].filed2
How can I get the min value of field1? I can't do:
@{min(activity('get_data_list').output.filed1)}
because the output is not a list of integers, it's a list of rows.
Hi amaaiia ,
With your description, if you want to get the minimum value of field1, you can use a loop to traverse the list and apply the min function to the extracted value.
Refer to below:
# Assuming get_data_list returns a list of rows data_list = @activity('get_data_list').output # Extract field1 values from each row field1_values = [row.field1 for row in data_list] # Get the minimum value of field1 min_field1_value = min(field1_values)Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi amaaiia ,
With your description, if you want to get the minimum value of field1, you can use a loop to traverse the list and apply the min function to the extracted value.
Refer to below:
# Assuming get_data_list returns a list of rows data_list = @activity('get_data_list').output # Extract field1 values from each row field1_values = [row.field1 for row in data_list] # Get the minimum value of field1 min_field1_value = min(field1_values)Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.