Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to get distinct count of below expression,
=count( {$<UNIT_SINGLE={'UNIT'}>} Distinct(DATE,UNIT_NAME) )
but that doesn't work,
I want to get distinct UNIT_NAME count. but i have to check it with the date.
i mean in the next week i can have same name.
SEE BELOW,
UNIT NAME UNIT_SINGLE DATE
ABC UNIT 2013/02/15
ABC UNIT 2013/02/15
CDE UNIT 2013/02/15
ABC UNIT 2013/02/25
So i want to result for FEB
NUMBER OF DISTINCT SHIPDATE,UNITS
THAT MEANS= 3
PLS HELP
THANK YOU
Try with concatenate operator
=count( {$<UNIT_SINGLE={'UNIT'}>} DISTINCT DATE & UNIT_NAME)
That is not possible, the solution is to concat the fields in order to manage only one field (ex.
ABC_2013/02/15 as new field
Hope it helps
SHIPDATE and UNIT_SINGLE is in two tables. So pls help me
join the tables (outer join if now are associated) so all fields will be in only one table:
Tab_All:
noconcatenate
select * ... from ... table1
outer join
select * ... from ... table2
MyTable:
noconcatenate
load
*,
field1 & field2 as newfield
resident Tab_All;
drop table Tab_All;
Then use newfield in the count distinct
Try with concatenate operator
=count( {$<UNIT_SINGLE={'UNIT'}>} DISTINCT DATE & UNIT_NAME)
Thanks All.
Thank you very much.