Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have several excel files with several tables. Each file and table contains a column Index with a numeric value. For a special application i just want to summarize the index from a specific table in the excelfiles. How can i write this in a script and call this sum something else than sum(Index). Sum(Index) is used in graphs, tables.
/Anders
Hi,
As i understand you can use the variables and store sum(Index) there and where ever you want to use it use with the help of variables.
if you have any sample file so share it.
Regards
Anand
Hi,
Or i suggested you to use resident table.Please if you have any samnple so provide to me.
HTH
Regards
Anand
If you want to sum fields in a load statement, you have to use a group by clause as part of the load.
Load
sum(index) as IndexTotal,
...
...
From MyTable group By SomeField;
Hi, this is the script i am using. How do i sum the column index in the script? have tried sum(Index) as ..... but it doesent work, perhaps i writing it in the wrong place in the script? suggestions?
So that script will build the table. After all the excel files are loaded, you will need to do a resident load with a group by statement.
Load
Anlaggning,
sum(index) as totalIndes
Resident data group by Analaggning;
I am guessing on how you want to do the group by.
Hi,
sorry for late feedback, problem fixed
/Anders