IDEAScript Questions

Hello,
I just want to know how to unpivot columns in IDEA. The example below is what I am trying to accomplish.  Thanks for the help!
 

Name           Grant Name          Amount

John                 Grant 123               1,000

I have a script to create an array with the fieldnames of a database. But for a check i need to exclude two fields of which i know the name. But is it possible to search the array for a match and remove that row in the array?

Hi.  I am working on a project to compare a data set DATATABLE with customer names (CUSTNAME field) against a separate table KEYWORDS with 1000 words.  I want to either filter, or extract/return, results if there is a the CUSTNAME field contains any word in KEYWORDS.
Is there a way to do this?  I'm thinking probably a loop to go through each of the data elements in the key words table and then to do a "contains" comparison with isini or something?  Just wanted to see if there was a way, or code available, to do this.  Thanks!

Hi @ all,
i tried to compare 2 pictures within a dialog.
But it doesn't work. Has someone a suggestion to solve the problem?
Thanks a lot
Jan

Hi Brian,
Hope you're doing good. Am looking for a Idea script which can be used to knock off positive and negative values from a data set taking into considerations the GL codes as well.
Currently, I am able to perform this in an excel file by using the below mentioned formula,
“=(COUNTIFS($B$2:B2,B2,$A$2:A2,A2)<=MIN(COUNTIFS($B$2:$B$1000000,-B2,$A$2:$A$1000000,A2),COUNTIFS($B$2:$B$1000000,B2,$A$2:$A$1000000,A2)))”

I can't get the IDEA script to open a Excel file, i also can't find the answer on Google. Is there anyone with some experience with this?
 
Sub Main
Dim Workbooks As Object
Dim ActiveWorkbook As Object
Dim File As String
File = "H:\!OHW\IDEA\Test Project 01 (9999990)\Import Definitions.ILB\Import definitions.xlsx"
Set Workbooks = CreateObject("Excel.Sheet")
Workbooks.Application.Visible = True
Workbooks.Open (File)
 
'Workbooks.Application.Quit
'Set Workbooks = Nothing
MsgBox "Gereed"
End Sub

Helo,
Could someone help me with this case. I have file name that contain date format.  Could anyone help me with scripts that can  import automatically based on now date and one/two/three days before.
 
Thank you for your help.

Hi,
Is it possible to create an IDEA script generating text file in which list down all field modifications and new field creations?
For example, the field "Date" when imported will be renamed to "SaleDate" and this field will be used to create a new field called "FinalDate" later
 

Is it possible to export multiply IMD files to one Excel files in different worksheet tabs?
And is there a good guide on how to use VBA Excel? I want to add more worksheets tabs and add text to the diffrent worksheet tabs. I got this far with Google:
 
 
Sub Main
Dim ExcelSheet As Object
Set ExcelSheet = CreateObject("Excel.Sheet")
ExcelSheet.Application.Visible = False
ExcelSheet.Application.Cells(1, 1).Value = "This is column A, row 1"
ExcelSheet.SaveAs "H:\!OHW\IDEA\Test Project 01 (9999990)\Exports.ILB\TEST.xlsx"

Hi I just found this site and am excited by all the infomation.  Some of the .iss macros/scripts look like they would be very useful but I don't know how to get them from the IDEAScripts to my IDEA.  We are on version 10.4.