Hi Nicholas, My guess is that some of your columns of center table are typed as integer. Integer or not, internally it always use double type to calculate the centers and score/distance, but convert it to integer when output to the center table s...

Hello, Well, the reason is simple. AD does not recognize your ordering, it simply treats it as an numerical variable. Kmeans does not recognize your ordering either. In this condition I suggest make ordering start with 0 which still holds you...

Hello, Your column containing colors is normally called categorical data in PAL. Normally it should be transfer to binary columns like (1, 0, 0) for Red, (0, 1, 0) for Orange and (0, 0, 1) for Yellow. The column number equals the category number,...

Hello, "Score" is defined as distance to its cluster center or total distance to all centers depending on the parameter OUTLIER_DEFINE. The results in example of PAL document can be reconstruct as well. If you come across a situation otherwise,...

Hello,There is a line :INSERT INTO #PAL_CONTROL_TBL VALUES('CATEGORY_COL', 3, NULL, NULL);It indicates that column "V003" is a category column (counting starts with 0) which makes it only support integer and string type.Best RegardsZee