Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello experts!
I have a field "country" in which countries related to some products are listed in this way:
Product | Country | ... |
---|---|---|
xxx | Italy | ... |
zzz | Italy | France | Germany | ... |
www | Germany| USA | Denmark | Spain | China | ... |
I would like to create a filter pane that filters data by country, but with countries listed like this i have some issues. I cannot split countries in multiple fields because the filter pane has to be unique.
Any help?
Thank you!
Try this script
Table:
LOAD * INLINE [
Product, Country
xxx, Italy
zzz, Italy | France | Germany
www, Germany| USA | Denmark | Spain | China
];
LinkTable:
LOAD Country,
Trim(SubField(Country, '|')) as CountryFilter
Resident Table;
Use CountryFilter field for filtering
Try this script
Table:
LOAD * INLINE [
Product, Country
xxx, Italy
zzz, Italy | France | Germany
www, Germany| USA | Denmark | Spain | China
];
LinkTable:
LOAD Country,
Trim(SubField(Country, '|')) as CountryFilter
Resident Table;
Use CountryFilter field for filtering