Actually, I have a issue with [studio]. I need to calculate sum,max and min for multiple columns in excel(attached is query which i have posted couple of days back in forum)
Hi all, I need to calculate sum,maximum and minimum for all the columns in the attached excel sheet. Can you please help me out with this ASAP. [image]
The solution given by them is ok and its working fine but When i’m giving the expression ‘dt.AsEnumerable…’ in assign activity in a normal sequence its working and the ‘.sum’ function is visible but when i invoke the sequence and do the same, ‘.sum(func…’ is not working after i type ‘dt.AsEnumerable.’
This is happening only on my desktop\studio whereas its working in any other desktop.I have tried uninstalling [studio] and re installed. and done workaround as mentioned here : AsEnumerable is not a member of ‘System.Data.Datatable’
but still can’t access ‘.sum’(or ‘.max’ (or) ‘.min’) functions inside the invoked sequence.
Can anyone please look into this issue?
Thank you in advance.