Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I was trying using Min/Max aggregate function in Set Analysis. I used function in different way and got different result.
LOAD SCRIPT
**********************************************************************************************************************************************
Data:
Load *
Inline
[
Marks, Name
150, A
250, B
120, C
320, D
188, E
235, F
354, G
199, H
297, I
];
NewData:
Load
Max(Marks) as MaxMarks
Resident Data;
Let MaxMarks = Peek('MaxMarks',0,'NewData');
Drop Table NewData;
**********************************************************************************************************************************************
Function : =Concat({<Marks={"$(=Min(Marks))"}>}Name,';')
Output: C
Function : =Concat({<Marks={"=Min(Marks)"}>}Name,';')
Output: A;B;C;D;E;F;G;H;I
It seems, in second case.. it is going row by row but I think, it should not be the case when use set..
Please share your thoughts..!!
Thanks,
-Kamal
Thanks for quick response, the reason why I asked this was.. if I want to calculate row by row and want to have all the items concatenated.. I can easily use..
=Concat(Name,' ;')