Form relationships between two columns from two tables

[Anonymous]

I have one table with a unique reference i.e. 'SPP009(b)', and I have another table with a unique reference i.e. 'SPP009(b) - text'.

The second table has text after the unique reference number within the column.

How do I make a relationship between these two columns if one has only the reference and the other has the reference and description?

[Singaravelu_R · Accepted solution]

Duplicate the same text column as per screenshot in query editor,

and Transform split column 

and close and apply the query editor follow the steps as per screenshot,