SQL View Name:columns_eda_stat_disc
SQL View Number:6068
Group:Analytics
Base Table:eda_sts_dsc
Description:The previous view fetches duplicated values - with model and without model. In this view we remove the duplicated values
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsComment
disc_valueCHARvarchar 255  Name of the value 
objidLONGint3  DIRECT Internal record number 
percent_occurencesFLOATreal    The percentage of records with this value 
struct_list_objidLONGint   DIRECT Internal record number for struct_lst 
subset_objidLONGint   DIRECT Internal record number for subset 
upper_boundFLOATreal    For discretized attribute, the point of the value 
value_countLONGint   DIRECT Number of records with this value 
value_formattedCHARvarchar 255  The percentage + '%' + value_name; e.g '20% NY' 

SQL:

(SELECT
objid
, struct_list_objid
, disc_value
, percent_occurences
, value_count
, value_formatted
, upper_bound
, subset_objid
from
table_columns_eda_stt_dsc_temp
where model_objid is null)
My Recent Objects
columns_eda_stat_disc