Cross Table Concept

[abhaysingh]

Hi all,

i have one value field, which is made after using cross table and values are repeating.. how i can make these repeated values distinct?

regards

Abhay

[danieloberbilli]

you would have to load it in another logical table like:

Cross1:

Crosstable(attribute,data,2) load

ID,

Category,

F1_1,

F1_2,

F1_3

resident Data;

CategoryDist:

Load distinct

Category as Category_distinct

resident Cross1;

[abhaysingh]

Hi Thanks for revert,

but i want to have distinct value like outstanding values... and after resident what should i do ?? will do concatinate with resident table?

thanks

[danieloberbilli]

Not sure what you try to achieve.

If you would like to have distinct values in your crosstab - that won't work as you would loose information.

imagine

ID  Category  attribute   data

1     A          F1_1          100

1     B          F1_2          50

2     A          F1_1          30

2     B          F1_2          75

If you would try to enforce a distinct value within that table - you would loose all information