IDEAScript Questions

Hi everyone.

I'm sure this must be a relatively straightforward, but wonder if someone could help with the below.

I have an ODBC import script, which performs various pieces of analysis, then exports the results.

Hey guys,
I've got the following task:
In order to check bookings, I created the macro, that does everything I need it to do.
The tables I run the macro on, always have the same structure. My problem is with the file names - they always have a time stamp in their name, from when they're downloaded.
I'd like to automate the macro, so that they can run on any file without having to rename the files everytime.
The file names look like this:
 
YYYYMMDDHHMMSS_SP1_ABCD
 

Hi,
I wanted to see if there is a quick way to copy everything I already put together in this dialog and paste it into another idea script project?
 
Or if there is a way to generate the code that contains that dialog and copy and paste it into the script of the new project?

Hi,
I have been asked to compare expenditures related to  the same client over two years.
I need to create a DialogBox that prompt the user to select the databases and call them to do some grouping and comparison.
I was trying to get inspiration from Brian's youtube video but I got stuck with a sintax error I can't understand.
I attach the ISS file.
As I am still learning how to code I will go with doubling the test on each of them and use a recorded macro to work with DBjoin, comparison and Analytical Review.
Thank you for your help.

Hello Bryan,
I have a problem with my dialog box.
I created one with IDEA script dialog box menu and add an drop list box.
My problem is that I can't mange to know what did the user picked up !
I've search for a solution for a such long time but didn't manged to fix it.
I tried this in my code :
Button = Dialog (Dlg1) ' Dlg1 is the name of my dialog box 
If Button = -1 Then
MsgBox "You selected" & Dlg1.DropListBox & "as the color" 
Else
MsgBox "You clicked Cancel."
End If 
Could you help me ?

How hard is is it to take an existing script and cut out the part you want and add it to a new script that I've written?  For example Brian has a script called Date Creation Database and I want his dialog box (opens a box where you enter a start date and an end date and then buttons for equal to, etc) but I want to add that to a IDEAScript that pulls certain columns from a table (database).  Then apply criteria to dates to show me those invoices who have doc dates less than invoice receipt dates.

Hi!
I have a huge database (1 million records) en which I would like to find similarities within one field. The problem is that Fuzzy function is too slow. I have tryied to do it comparing one woth the rest by using ideacript, but I can't find the function which gives me the similarity between two names.
SimilarPhrase and SimilarWord aren't working in ideascript. Does anyone know how to find if two names are similar, from ideascript?
Thannk you!

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