Title: Is it possible to use DataView to display whether specific keywords exist in items (files) based on different folder names?
For example, There are files in two different folders
in Folder A:
In Folder B:
I would like to represent it in the following table:
wanna list only unique problem number and show either they exist in folder A or B
No. “cpp” “py”
I have no idea how to combine duplicate problem numbers.
TABLE name, contains(file.name, "cpp") as "C++", contains(file.name, "py") as "Python" FROM "2. Area/BOJ Problem Solve" WHERE contains(tags, "23-10") AND (contains(file.name, "cpp") OR contains(file.name, "py"))