The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
sparse table
Learner III
hey all,
I'm trying to generate a table containing a pivot.
the input data is the gender result file,
it contains data attributes in a sparse format
- here is the header:
avgOfProb, countOfProb, sumofprob, id, piv, label
where possible values for piv is: "M", "F", "Other"
which means that for each uuid, i have values of avgOfProb, countOfProb, sumofprob for each possible "piv" value.
i need to generate an example set containing these colomns:
id, label
M_avgOfProb, M_countOfProb, M_sumofprob,
F_avgOfProb, F_countOfProb, F_sumofprob,
Other_avgOfProb, Other_countOfProb, Other_sumofprob,
but when using the Pivot element, all I get is the last 9 coloumns.
I'm trying to generate a table containing a pivot.
the input data is the gender result file,
it contains data attributes in a sparse format
- here is the header:
avgOfProb, countOfProb, sumofprob, id, piv, label
where possible values for piv is: "M", "F", "Other"
which means that for each uuid, i have values of avgOfProb, countOfProb, sumofprob for each possible "piv" value.
i need to generate an example set containing these colomns:
id, label
M_avgOfProb, M_countOfProb, M_sumofprob,
F_avgOfProb, F_countOfProb, F_sumofprob,
Other_avgOfProb, Other_countOfProb, Other_sumofprob,
but when using the Pivot element, all I get is the last 9 coloumns.
0
