IDEAScript Questions

Hi, i want to analyse a dataset with a number of financial statements elements and periods. The problem i have is that for the analysis i need for every element all the periods. But the source file sometime doesn't have a mutation in a period.
How do i create this:

Financial statement element
Period

creditors
2019-Q1

creditors
2019-Q2

creditors
2019-Q3

creditors
2019-Q4

debtors
2019-Q1

debtors
2019-Q2

debtors
2019-Q3

Hi!
I want to get all different filelocations from one culumn in an array without duplicates.
 

 
Hello, I am calculating total field, and it always asks me for confirmation. I would like to know if it is possible to code the OK always. Or if the total of the column can be added in another way, the example is welcome. Thank you

Is it possible to create muliple joins across what is 6 different tables like I can do in SQL?  I have 7 Left Outer Joins in an SQL script that I'd like to duplicate withing IDEA.  We are upgraded to version 11.

Hi everyone!
I'm a beginer in Idea Script and here is a code i ended up with after having recorded a macro :
Sub Main
Set db = Client.OpenDatabase("GLOriginal-Travaillé.IMD")
Set task = db.TableManagement
Set field = db.TableDef.NewField
field.Name = "TYPE_DE_COMPTE"
field.Description = "Ajouter une type de compte pour bâtir TCD"
field.Type = WI_VIRT_CHAR

 
Hey ı wanna create new column record.But ı take error.Can you help me ?
 
 
 

I have an IDEAScript I built that I want to have run on the 21st of every month.  Is there a way to set this up?

Is it possible with IDEA scripting to read a specific value of a field into a global variable?

Hi, 
I uploaded an image below. There you should see two records. And I want to do an algebraic operation, namely division, between the two "NET" values, i.e 486.449,01/-189.093,80 and then I want to display the result in a new field and in a new database. How can I do that either with IDEA itself or with IDEAScript? Like divide the NET value where HESAPNO == "1" with the NET value where HESAPNO == "3", so that I can perform similar operations for other values of HESAPNO as well
Thanks
 

I know is just copy and paste but is it possible to join more than 2 sheets into a single *.IDM file? Any example, please?
 
Greeetings!