How can I ...Compare two indices fields if data matches then create new index and store the matched data into it

Was thinking if I can use sub queries either "union" but left with nothing as above is not supported

There isn't a builtin way to do this, you'll have to create your own script that does this.

will canvas help me compare two index and draw table accordingly???