General discussion

Hi everyone, just to let you know there is a site called Auditopia where they have lots of free training in data analytics.  Also the site is undergoing changes and until Feb 22, 2024 you can join the groups for free, one of them is on IDEA, after that date the groups will only be for pro members, I would suggest you check it out.

https://auditopia.com/groups-list/

Hi Brian,
I hope this message finds you well. I am reaching out to seek assistance in sorting the columns of my table based on our fiscal year, which runs from April to March. The table may include only a subset of months, for example, from April to August.
I am wondering if there is a more efficient way to achieve this rather than manually sorting the columns. I attempted to use an "if" function, but I encountered difficulties in implementing it successfully.
Ideally, I would like to extract the data with logic similar to the following:
 
 

I was using IDEA and running some scripts, suddenly I encountered the attach pop up.
I have check that the system anti virus is not blocking the software.
How can I solve this issue?

When applying criteria IDEA freezes at 0% with any file.  I imported a tiny 3 row, 2 field test file.  I set a criteria and it worked ok.  Then if you close and reopen the file it just sits at 0%.  IDEA is being run from a local drive (not network) and i have full permissions on the location. Any ideas?

Hi!
I'm looking for a script that would append additional column into my ile with values equal to source file name.
In my example I have text files e.g.  20230831.txt with one column of data.
I would like to import this file into IDEA and have to column of which one would store in every field value "20230831".
If there would be a way to import multiple file this way at the same time that would be excelent! :)
 
Thanks in advance for the help!
Regards,
Maciej

Hi,
 
I am importing a text file which has 32 lakh records but upon import idea shows only 16 lakh records. 
 
Can someone help me what could be the reason. System has enough space

I am trying to import a table with today's date, that is, current. but it throws an access denied error on line 8.
example
Sub Main
 Call ODBCImport()
End Sub
 
Function ODBCImport
' para esta tabla rango de fecha para tomar el balance que quedo. 
dbName = "Devengo.IMD"Am I not doing it properly?

It only tells me an error on line 9, but it does not specify the error that it is.
 
Sub Main
Call ODBCImport()'
End Sub
 
 
' Archivo -Asistente de importación: ODBC
Function ODBCImport
dbName = "FISA.TCLI_CLICTA.IMD"

greetings,
How can I change the names of the fields in a table to be able to export it in excel. Is there any script that can help me.
Thank you

Hello, Does anyone have a macro to send automatic mail in IDEA.I am carrying out several daily test extractions, I must send the result by email in Excel, of course after exporting it, but I want to do it automatically, without going into each Excel generated and manually sending it from IDEA.
Do you have something out there that you can enlighten me on?