Table join issue

[#1]

Dear friends,

I have three tables call table_A,table_B and table_C.

when i create a dashboard linked with this three tables (from ItemID) i can see all the data in this all three tables.I want to show the data only get from table_C.

Ex. only need to show the data of item 1 to 10 in any ware on the dashboard.

[sushil353]

Hi,

for this you can simply make use of join..

TableC:

Load * from sourceC;

left join(TableC)

load * from sourceB;

left join(TableC)

load * from sourceA;

HTH
Sushil

[sujeetsingh]

Load table C

;;;

;;From:

Left join Table A

'''

'''' from ;

left join table B;

[anbu1984]

Table_C:

Load * From Table_C;

Left Join(Table_C)

Load * From Table_B;

Left Join(Table_C)

Load * From Table_A;

[jonathandienst]

Hi

If one of the other fields in Table C is fully populated (no null values), then use this field as a filter in a list box or calculated dimension:

          =Aggr(If(Len(FieldC1) > 0, ItemD), ItemD)

Otherwise you might need to create a flag field in TableC to perform the filtering

HTH

Jonathan

[#6]

hey damitha,

try this,

load * from table_C;

left keep(table_C)

load * from table_B;

left keep(table_C)

load * from table_A;

or

load * from table_C;

load * from table_B where exists(itemID);

load * from table_A where exists(itemID);

cheers,

kunal bhattacharjee

[jagan]

Hi,

Try this script

Table_C:

LOAD *

FROM table_C;

Table_B:

left keep(Table_C)

LOAD *

FROM

table_B;

Table_A

left keep(Table_C)

LOAD *

FROM

table_A;

Hope this helps you.

Regards,

Jagan.

[#8]

this will work

Load * From table c;

left join(table c)

load * from  table b;

left join(table c)

load * from table a;