Questions on IDEA Analysis

Hi all,
 
When i execute the attached code (still work in progress) it is supposed to open 3 excel files and display the list of the fields in the dialog box for the user to chose appropriate field. Each time it should display 'N/A' in the drop down menu but it doesnt when i select something in dialog box in 1st run. It must be something with the iteration of the ListofColumns but I am not sure how to resolve it.
Thank you for your help in advance.
 
 

Hi Brian,
Hope you are well.
Quick question about fuzzy duplicate:
I am try to group similar names coz names come in as free text and tend to error prone.
Current output from fuzzy duplicate match:
Name                                   Group Name (from Fuzzy)

Hello,
I'm beginner in IDEA
Please how can do VLOOKUP execution like in Excel ?
Specificly, i want to obtain B1..x value ( from DataBase B) in DataBase A, base on key value x in DB A and B.
 
Thank you

Hello all,
 
I am trying to adjust my function that search for specific word with the use of @Isini pre built IDEA function.

I have created a very simple piece of code that does a few analysis between 2 files. The problem is that it works correctly only for the first run when the analysis on both files are executed very first time. When I run that code again on the initial 2 databases I used in first place the code generates the error - "Error on line 259" which is task.PerfromTask while summarization function is executed - as the error is quite ambigious I am not sure how to resolve it. Additionally the IDea gets closed immediately after this error.

Hello,
I am currently wanting to replace all the cells in one column (column A) that have a value of "0/00/000" with a value in the same row from another column (column B).
Basically, if Column A Cell 1 = "0/00/0000" then replace Column A Cell 1  with Column B Cell 1. I am very new to IDEA but I thought appeneding a new field with the following was a good start.
@If( ColumnA == @Ctod("0/00/0000" , "D/MM/YYYY"),   ColumnB )
I have tried a few other things that I thought might get me close to no real effect. Any ideas?

 
Hi all,
 
In my code i am using a dialog box with number of Checkboxes and Textboxes. To verify wheter the user checked any CB or provided string with TB i use the following code respectively:
 
                             If dlg2.CheckBox1 = 1 Then

Hello all ,
Does anyone know a quick guidance/tutorial (video, web page) I can use to learn how to import GL in word document (text)?
I had a quick go but I cannot get the GL into the shape I wanted to see it in IDEA.
Any help is much appreciated.
 
Regards
 

Hello guys 
I am new in Idea analysis software
Im wondering if there is a function to extract a string by deleting first letter and last letter 
for example,
9peter019  I want to extract peter01 
I want to apply this in the name_field 
 
thank you 
 

Hi, I'm trying to select 5 random samples for each subcategory in a database. I know I could extract all the records for each subcategory and make a random selection for each of those, but there are too many subcategories to do that efficiently. Does anyone know a way to use rational subgroup samping in IDEA?