Loop +Aggregate; color to a column
Teja_Varanasi
New Altair Community Member
Hi, I have say S.No, Required, A, B, C, D, E.... 2 columns are surely present (S.No, Required) and others are unknown. But at least 1 will be there.(S.No, Required, A). What I want is to multiply Quantity* A, Quantity*B,Quantity*c like that.. with all the columns except S.No. later want to add all the values => sum(Quantity*A),sum(Quantity*B).. finding the min of those sums and represent the min col in green color
what i am trying to do:
loop => dynamically generate attribute for Quantity* A, Quantity*B,Quantity*c ; want to aggregate only the generated columns in inside the loop.. as the number of columns are unknown. Unable to do this. Can somebody please suggest what to do.
Correct me if i am wrong.
what i am trying to do:
loop => dynamically generate attribute for Quantity* A, Quantity*B,Quantity*c ; want to aggregate only the generated columns in inside the loop.. as the number of columns are unknown. Unable to do this. Can somebody please suggest what to do.
Correct me if i am wrong.
Tagged:
0