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
Hi there. For a long while i
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.
Hi there. I'm getting back to
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.
Hi there.
Hi there.
Brian, ¿is there any way to append rows to an excel file from ideascript?
Thanks in advance!