topic Re: Data not aligning in Associated Tables in App Development

Data not aligning in Associated Tables

AB108 — Fri, 04 Aug 2023 17:41:59 GMT

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 — Fri, 04 Aug 2023 18:30:14 GMT

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

load * inline [

A1, A2, A3

1, 11, 111

2, 22, 222

3, 33, 333];

Load * inline [

A1, B1, B2

1, A, AA

2, B, BB];

AB108 — Fri, 04 Aug 2023 19:09:52 GMT

@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