Hello, your example is very good!
It is similar to what I need to do but it does not have the same structure, since the data related to each other is part of another data structure that I cannot vary.
Each “Attribute” and each associated “Value” are also part of other structures that for example calculate product costs, etc. Let’s say they are not used only as aesthetic attributes of the product.
Anyway, after many hours! I think I managed to advance a bit …
As what I need to do is based on a json template that I need to prepare to send by webhook to another application, I managed in part to format this information in there with the << Start: >> <> functions
"attributes": [
{
"id": "2",
"name": "Color",
"visible": true,
"variation": true,
"options": ["Blue", "Green", "Green"]
}, {
{
"id": "2",
"name": "Color",
"visible": true,
"variation": true,
"options": ["Blue", "Green", "Green"]
}, {
"id": "3",
"name": "Material",
"visible": true,
"variation": true,
"options": ["Wood", "Steel", "Paper"]
}
]
Example “name”: “Color” is repeated, and “Green”, “Green” is repeated …
"attributes": [
<<Start:
FILTER("Products Variations Attributes Links",
([Product] = [_THISROW].[Key])
)>>
{
"id": "<<[Products Variations Attributes].[Id]>>",
"name": "<<[Products Variations Attributes].[Name]>>",
"visible": true,
"variation": true,
"options": [
<<Start:
ORDERBY(
FILTER(
"Products Variations Attributes Links",
AND(
([Product] = [_THISROW].[Key]),
([Products Variations Attributes Options].[Products Variations Attributes] = [_THISROW-1].[Products Variations Attributes])
)
),
[Products Variations Attributes Options]
)>>
"<<[Products Variations Attributes Options].[Name]>>",
<<End>>
]
},
<<End>>
]
Now what I can’t do is to be able to filter only the unique values, I need no duplicates.
Do you know how I can modify those formulas to avoid duplicates?
Thanks !
LinkedIn
Twitter
