General discussion

Hi everyone,
 
Do we have "CROSSTAB" function in IDEA? I know we can make it via pivot table but the problem is IDEA does not create macro for a pivot table!
I am looking for this function to make it manually and then save it into a macro for future work.
The link below is a description for crosstab query:
https://support.microsoft.com/en-us/office/make-summary-data-easier-to-…
 

Hi everyone,
 
I am wondering if there is a way to return the time portion from a datetime character value?
I tried @Ctot function but it returns "00:00:00".
I mean it should pull "01:28:31" from "12-Apr-2021 01:28:31". I am looking for a function not macros scripts.
 
Thanks,
 

Hi everyone,
I wanted to know if we can create a project inside another project?
 
Thanks,

Hi everyone.
I cannot select the fields I want to search. All the fields are character and I type text in the "text to find" box!
Thanks,

I'm adding errorhandlers to a series of pre-existing scripts.  These scripts are for analysts with a wide variety of technical ability to use so I'm trying to keep them simple.  One thing I've been unable to find is a list of the properties IDEA makes available for an error object (.number, .description, .WhatElse?).  The two scenarios where I need more information than I have are as follows:

Hi everyone,
I wanted to know if there is any way to export my tables as Excel format (each should be in a separate sheet) into a single Excel file. Tables a, b, and c should be exported as different sheets into an Excel file named "X".
 
Thanks,
 

Hi everyone,
I have a source data (an IMD table) in a project and I am updating this data every month. Generally, I was wondering if there is a way to import the IMD file from another project to a prjoect! I know I can copy and paste into the project but I am looking for another way.
Thanks,

I just uploaded a vidoe on my YouTube channel on using User Types in IDEAScript.  Here is the link to the video and I have attached the script that I used for the demo - https://youtu.be/B56E8LYIuZM

Hello,
I converted a xls file to xlsx file to import itnto IDEA. It seems IDEA does not support xls, right?
Then, I tried to import xlsx (Excel 2016) but question marks appear at the beginning and end of each string (character) cell!
How can I import the data without having question marks?
Please see the images

Hola quisiera de su ayuda deseo llamar un Scrip cuando finalice uno para evitrar tener tantas lineas de codigo en uno solo