Data not aligning in Associated Tables

[AB108]

Hi,

I am associating two tables using a common field name. 

A---A1,A2

B---A1,B1,B2.....

I use text(A1) to associate the two tables.

When I try to create a table in the Dashboard with A1,A2,B1.B2.... There is always an extra row with '-' for columns from B.

The load script and the Sync table in table view show the association as expected.

[Vegar]

Could it be that you have A1 values  in table A that does not exist in table B?

EXAMPLE below will give no values in a straight table for rows containing A1= 3

A:

load *  inline [

A1, A2, A3

1, 11, 111

2, 22, 222

3, 33, 333];

B:

Load * inline [

A1, B1, B2

1, A, AA

2, B, BB];

[AB108]

@Vegar  That's not the case.  Both th tables have same values. Moreover this is what I am getting if I put the values in a table

A1,A2,B1

1,11,-

1,11,A

2,22,-

2,22,B