Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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
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