I used an iterate task to record JSON object items on different rows on the sheet
On the screenshot, I want to assign a PDF Image Variable to a formula: LOOKUP([imagecolumn], some_filter, “DESC”,1) although the images are the same on the sheet I understand that they may be stored as different_names in s3 somewhere so I can’t use UNIQUE() (I tried but also did not work). I just want 1 image to show up
I want the same for other lookups assigned to text and list variable for items that are not part of the iterate task.
@chirag1, tagging you since this is an alternative solution to my other problem but there’s a blocker of repeating items and not being able to filter on just 1st row
Parsing a JSON from resulting LOOKUP()