General discussion

Hello everybody,
I am having difficulty in appending multiple sheets importing from excel. Why i tried to join these sheet together, the system notify me about the field format is different. Is there a way or any tips to mass formatting multiples sheets at one? Since having 50+ sheets to append might be time consuming.
Thank you very much,
Best regards,
Trung Nguyen

Hi All,
I need to deal with a field ( numeric type) containing a number called duration with this format for example : 14100 wich mean that the duration is 101 second, another exmaple :
1333800 = 5618 second
1410100=6061 second
So which function ca help me to get the result in second ?
Thank you.

Hi All,
Can you help or guid me to extract without duplicated data  ? 
column A (character type ):
1  
2
1
4
5
1
3
Thanks.

Hi All,
I have a field that contains a list of number separated by (,), what i need is : create a lot of field depended of how number contained in it ,
for ex : 3554249, 3554250, 3554251, 3554252  and the result that i'd like is for ex :

A
B
C
D

3554249
3554250
3554251
3554252

Thank you.

Hello,
 
How many different kinds of IDEA license are there?
- Client Version
- Server Version
- Single User Version
- Shared User Version
 
I am purchasing new laptops to run IDEA on standalone mode (Client Version).
What is the recommended laptop specification?
 
Thanks and Regards!

Hello,
 
I am using IDEA by extending my desktop across my laptop screen and another big monitor.
 
But when I am using IDEA in my laptop, I realise that some windows in IDEA will be missing / out of sight. 
 
Is this an existing problem with IDEA? If yes, are there any resolutions for this?
 
Thanks and Regards!

Hello,
 
I had joined a primary database to a secondary database using "Records with no secondary match" option where both databases have a common key.
 
After looking through the data in the joined database, I realised that some of these unmatched data to secondary database were found in secondary database.
 
So I re-joined the joined database to the same secondary database using "Records with no secondary match" option. And the output database had fewer records compared to the first join.
 

I have been trying to use this date type var in a dialog box but it is giving me an error
 
Dim StartDate, EndDate As Date
 
Sub Main
StartDate = dlgEnable.TextBox2
EndDate = dlgEnable.TextBox3
Call DirectMCINTExtraction()                
End sub
Function DirectMCINTExtraction
Set db = Client.OpenDatabase(InputFile)
Set task = db.Extraction
task.IncludeAllFields
dbName = FileName +"_INTL.IMD"

Hello everyone,
I have recently discovered some of the fantastic features and capabilities of this great software - IDEA. Now by my curiosity in studying the capabilities of the software I intend to apply to the database some statisticals. So what I intend to do now is: use the IDEA capabilities to estimate some coefficients, and for that I want to use (for now) the Ordinary Least Squares.
 
The goal will be:
Imagine that I have an equation like that:
Y = X * B + E
and: Y  -> only one column

Hello everyone from the forum!
I've been working with IDEA for some months already. Since then, I started to face some performace problems  that sometimes delay the deliveries in my work.
So I noticed that the CaseWear provides an alternative version of IDEA as a server that I do not know much about.