Skip to main content

General discussion

Report Export

Hi Idea Community!
I have a problem regarding exporting reports to pdfs.
Sometimes when i want to export report to pdf IDEA starts the export and i see tens/hundrets of pages beeing generated in the pop up window. If i would leave it there it could generate the report infinitely. There should be one or two pages tops usually. This occures sometimes on my machine and then suddenly the issue disapears. Unfortunately this can happen on other machines in my organisation and the problem wouldnt go away.
Please help!

Auditopia

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/

Sorting Table Columns Based on Fiscal Year

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:
 
 

IDEA freezing (not multi monitor 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?

Append file name as value in column

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