Table Filter and Charts field matching

Craig.Harley

I am merging 2 confluence tables using Table Transformer and only want to display the merged list where the value of Table 1 Column A are contained within the contents of Table 2 Column B. Apologies if this is a really basic question, but have been struggling with this for a while.

Performing the Join is easy enough, just struggling to get my head around the matching

The following is as far as i have got (the original query is more complex but essentially this)

SELECT
T1.'Column A',
T2.'Column B'
FROM
T1
JOIN
T2
ON T1.'Column A' LIKE T2.'Column B'

However this returns no results

Tim Kopperud

Hi @Craig_Harley , if I understand the question correctly I'm not able to reproduce this error, that means I get values returned when trying this.

I have the following setup.

Result:

Or with some added info:

 

Are you able to attach some images from your setup? It might help finding the root cause of the problem you experience.

TimK.