Is it possible to use DataView to display whether specific keywords exist in items (files) based on different folder names?

[mysticizer]

What I’m trying to do

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:

• cpp_1
• cpp_2
• cpp_3
• cpp_4

In Folder B:

• py_1
• py_3
• py_5
• py_7

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”

1. o o
   

2. o x
   

3. o o
   

4. o x
   

5. x o
   

6. x o
   

Things I have tried

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"))

[mysticizer]

TABLE
	contains(rows.file.name,"cpp") as CPP,
	contains(rows.file.name,"py") as Python

From "2. Area/BOJ Problem Solve"
WHERE contains(tags,"23-10")
GROUP BY number(file.name) AS "Problem No"
SORT length(rows)