Unexpected data in loading data from 2 tables using Key

Mon, 25 Aug 2014 06:54:04 GMT

Hello Team,

I am loading data from 2 tables using a key (combination of 5 fields) in load statement.

TRCK_TRAK_NO &'_'&TRCK_LINE_NO&'_'&TRCK_JOB_FLAG&'_'&TRCK_MACHINE&'_'&Date(TRCK_DATETIME ,'MM/DD/YYYY HH:MM:SS') as key,

BT_TRAK_NO&'_'&BT_LINE_NO&'_'&BT_RXCNC_FLAG&'_'&BT_RXCNC_MACHINE&'_'&Date(BT_RXCNC_DATETIME,'MM/DD/YYYY HH:MM:SS') as key

in which one table is a subset of other.

when i display the entire data in Table chart I am seeing data as below:

Table View:

When I select any of the parameters, it is perfect. but when i do 'Clear Selection', I don't want to see the marked above section.

Please help me in getting rid of this.

Thanks,

Deepa

Re: Unexpected data in loading data from 2 tables using Key

sushil353 — Mon, 25 Aug 2014 07:17:52 GMT

In chart>Dimension> check suppress when value is null.

Mon, 25 Aug 2014 08:43:54 GMT

It works.. Thank you Sushil,