General discussion
Summarization AverageIf
Forums
I have 90 Columns and I want the average of each column, but the only condition is to take the average of those whose values are more than 0. Like we do in Excel by using AverageIF(). How can this be done on IDEA?
- Read more about Summarization AverageIf
- 1 comment
- Log in or register to post comments
how to validate if an .IMD
Forums
hello, how to validate if an .IMD file is found in the working project directory to send a message to the user who must first verify that this file exists and then proceed with the execution of the tests.
- Read more about how to validate if an .IMD
- 4 comments
- Log in or register to post comments
APP UTILITIES
Forums
hello, recently I downloaded the "APP UTILITIES" through the passport option, it happens that I downloaded a file with a .DPACK extension, when I double-click it is imported, but I don't know where to look for it or where to put it, could someone tell me where to put it? or the steps to run it and see the scripts
- Read more about APP UTILITIES
- 2 comments
- Log in or register to post comments
add a year to the current date
Forums
Hello, I have to get a list of the documents to expire, where I have today's date (@date), it happens that for future expirations I have to add a year to this date, I have tried with @year(@ date() +1 but it only gives me 2023 and I want the entire date, that is, if today we are at 2022/09/23, the new date must be 2023/09/23
How would I achieve this?
- Read more about add a year to the current date
- 2 comments
- Log in or register to post comments
Delete Folder and Databases
Forums
What is the ideascript for deleting a folder and all the imd files within the folder?
- Read more about Delete Folder and Databases
- 2 comments
- Log in or register to post comments
dynamic table o pivot table
Forums
Hello, I am creating a pivot table in idea, and the script runs fine. The question is, how do I send this table to Excel through other scripts, since IDEA does not save it. any idea how to do it?, I want to automate all the tasks, but this is a small problem.
- Read more about dynamic table o pivot table
- 2 comments
- Log in or register to post comments
scripts exports an excel file every end of the month,
Forums
Hello.
my scritps exports an excel file every end of the month, my question is if I can put the date with a file name in the export, example 6/30/2022_Balanc_General, but not manual, as it will change month by month. You can or some suggestion, this to create a repository to create statistics per month
Importing Excels
Forums
I have 30 Excel files, and in every file the data starts from B6 Cell (with the heading). How can I import the data in idea properly so that it will pick the data from B6 cell.
- Read more about Importing Excels
- 1 comment
- Log in or register to post comments
Data Extraction
Forums
Hi Brian
I have a question for youPlease have a look at the screen shot I attached. I need to pull employees who have the same department and position in the whole table.For instance, Employee ID = 2 has the same department (c) and the same position (Admin) but employee ID = 1 changed the department and position. Also Employee ID = 3 is in the same department but changed the position. I am looking for such an Employee ID = 2
I do not know how to use criterias for such a probelm or write scripts
Thanks
- Read more about Data Extraction
- 1 comment
- Log in or register to post comments
downloading an excel file from a page
Forums
the macro downloads the file in Excel but when going to the ExcelImport routine it throws an error that says "initial load error", what is wrong with this routine? If the file downloads fine. Thanks
remove the http: so that the address does not stand out
Sub MainIgnoreWarning(true)
Call DownloadFile("//cdn.bancentral.gov.do/documents/estadisticas/mercado-cambiario/documents/TASA_DOLAR_REFERENCIA_MC.xlsx" , client.workingdirectory & "\Archivos fuente.ILB\" & "TASA_DOLAR_REFERENCIA_MC.xlsx")
- Read more about downloading an excel file from a page
- 9 comments
- Log in or register to post comments