Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Does Firstsortedvalue() function works in Load Script. It gives me Invalid Dimension if i load.
Thanks
You have multiple fields without aggregation which you have not added to the GROUP BY statement... you have three options
1) Add these to the Group By statement
2) Remove them from the load statement
3) add aggregation around them
It should, what is the exact script you are trying? Also, did you have Group By clause?
Load
DOC_ID,
FirstSortedValue( ACTION_INDEX,-R_C_Time_stamp) as R_C_Index,
ACTION_INDEX,
SENDED_TO_TIMESTAMP
Resident Add_Cancellation_Return_Status
Group By DOC_ID;
You have multiple fields without aggregation which you have not added to the GROUP BY statement... you have three options
1) Add these to the Group By statement
2) Remove them from the load statement
3) add aggregation around them