Forum Discussion

amaaiia's avatar
amaaiia
Icon for Skilled Sharer rankSkilled Sharer
2 years ago
Solved

How 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 @a...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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 Kong

     

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