Append & Append in IDEA

6 posts / 0 new
Last post
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57
Append & Append in IDEA

Hi,

A closer look at Data under the IDEA tool-bar will reveal a function 'Append' - Fields.

'Append' under Fields in Data allows you to append or add fields to the active database.

You may need to add fields to perform calculations or reassess values in the accounting system or derive values/strings or add comments - limitless possibilities.

On the other hand 'Append' under 'Relate' in Analysis allows you to merge databases into a single file for further analysis.

This is particularly useful when you receive a single report in parts from an accounting system for better load balancing on the system. 'Append' under 'Relate' in Analysis can be used to merge the smaller files into one larger file for further analysis.

Kind Regards

Jairam

idemnos's picture
idemnos
Offline
Joined: 06/17/2016 - 13:25

Hi there.
Brian, ¿is there any way to append rows to an excel file from ideascript?
Thanks in advance!

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Yes there is, IDEAScript allows you to access excel spreadsheets and read / modify them.  What where you thinking of?

idemnos's picture
idemnos
Offline
Joined: 06/17/2016 - 13:25

Hi there. For a long while i've been exporting data to excel files, but what i do is to run my script from the beggining of the year to the last day , and overwrite the file generated the past month. The matter is I would have to check the last date generated and consider the current date minus 1 day. I guess.

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi idemnos,

I don't quite understand your last line, any chance you can give an example so I can understand what you are trying to do.

Thanks

Brian

idemnos's picture
idemnos
Offline
Joined: 06/17/2016 - 13:25

Hi there. I'm getting back to this theme. What I was trying to explain is:
My query have a range of dates: the initial date is the first day of the year (01/01/2020). The second date is yesterday, if we are al 13/03/2020, then the last date is current day minus 1. 
What I'm trying to do is to make idea select by function the parameters to let the schedule manager run periodically the script.