Show Values in a Table for a Particular Field

[#1]

Hello!

I have the following tables:

Table1:

• ACCOUNT_ID
• INSPECTION_DATE
• AMOUNT

Table2:

• ACCOUNT_ID
• STATUS

I want to show in a Simple Table the Table1 fields (ACCOUNT_ID, INSPECTION_DATE & AMOUNT) for those STATUS in Table2 where STATUS = Planned (STATUS could be: Selected, Planned, Inspected).

Do you know how can I do that?

Thank you!!!

[its_anandrjs]

Try one of this load

Table1:

Load

ACCOUNT_ID,

INSPECTION_DATE,

AMOUNT

From Location;

Right Join

Table2:

Load

ACCOUNT_ID

From Location

Where Match(STATUS,'Selected', 'Planned', 'Inspected' );

In place of the right join you can try with mapping table of table2.

[#3]

You can try this one, kinda similar to one mentioned above -

NewTable:

Load

ACCOUNT_ID,

INSPECTION_DATE,

AMOUNT

From Table1;

Inner Join

Load

ACCOUNT_ID,

STATUS

From Table2

Where STATUS = 'Planned' ;

Thanks

[Anonymous]

Hello.

Try using ACCOUNT_ID and INSPECTION_DATE as dimensions and this as expression:

Sum({$<STATUS = {'Planned'}>} AMOUNT)

Regards.

[MarcoWedel]

just load your to tables as they are.

They will be associated via the ACCOUNT_ID field.

Create a tble box with the table1 fields and a listbox for the Status field.

Then select 'Planned' in the Status listbox.

hope this helps

regards

Marco

[its_anandrjs]

May be this is your correct result try below in load script and use only Planned Status

Table1:

Load

ACCOUNT_ID,

INSPECTION_DATE,

AMOUNT

From Location;

Right Join

Table2:

Load

ACCOUNT_ID

From Location

Where Match(STATUS, 'Planned' );