Related to this, I tried doing the same aliasing to my two-letter country code, e.g. Country: US
to Country: "[[United States of America|US]]"
so I can also have a list by country page.
However, your awesome solution to my earlier problem from a few months ago, now no longer works, meaning I broke my query again:
FLATTEN join(map(split(Country, ", "), (c) => {
BZ: "🇧🇿",
CA: "🇨🇦",
US: "🇺🇸"
}[c])) AS Q_FLAG
I can’t figure out how to implement this with the aliasing, since I now separate the Countries like this:
Country:
- "[[United States of America|US]]"
- "[[Canada|CA]]"
instead of like previously with a comma. The split
command no longer works, since there’s no longer a split by commas, but removing the split thing doesn’t solve the problem.
Something like this also doesn’t work:
FLATTEN Country {
BZ: "🇧🇿",
CA: "🇨🇦",
US: "🇺🇸"
} AS Q_FLAG
Can this be fixed? Thanks!