I have 2 tables called product and variation, in the product table there is a product image and in product variation there is a product variation image which represents the image in the product table, for example I have a photo of a clothing product in the product table, and in product variation I have a photo of the product variation such as red, blue, black etc.
My question is, is there a way to combine the two product photo tables into one make array
You can add a Lookup column against the relation and then add a Make Array column to merge it with the product image.
if adding a lookup column doesn’t it just take the first one?
whereas in my data, one product ID can have 4 to 5 product variations
Your relation is multiple, so the lookup will be multiple.
great, I think it’s like lookup in excel which can only retrieve the first data, thanks Jeff
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
