General discussion

Hi , 
When I try to create a virtual numeric field for my Seller_ID which is a numeric record but it has character data type in database. Idea changes null vaules of my seller_id when I use @val or @justnumbers .
I need my null vaules , I dont want to see them as zero.
Can you help ? 
Best regards , 

Hello,
 
Here at Chiene + Tait we are a new user to the software during our external audits and are looking for tips on how to best use the software!
 
Hope to hear from you soon 
 
 

Hi Brian,
While using visual connector Am getting an error.
1. Variable not defined Id0. (Then I declared Id0 as Object)
Then got the next error
"Object variable or With block variable not set"Please help...below is my code
Function visualConnnectDatabase(resultFileName)Dim db As Database
Dim task As Object

Hi everyone, some of you may of noticed that I am not posting much right now and haven't been responding to posts.  I had a fall over the Christmas holidays and ended up with a mild concussion, nothing to worry about but I haven't had the energy lately to reply back to everything.  I am getting better everyday and hopefully will start to respond to peoples posts as I feel up to it.

Thanks

Brian

Hello, 
Would anyone be able to tell me how to add a specified number of months to a date? I'm looking for a function that has the same functionality as Excel's EDate function. For example, if I have a date of 10/1/18 in one column, and a number of "11" in another number, I would like to append a column that will add 11 months to 10/1/18, to return 9/1/19. 
Thanks!

I found this interesting article by Dave Coderre on identifying duplicates.  Thought it might be interesting to some people.

https://www.linkedin.com/pulse/identifying-duplicates-effectively-david…

Data science is being very popular these days and there are many fields in which it is being used. So, data science courses and training are provided to people who are interesting in learning and now one can get knowledge about data science even online on regular basis. Along with that, one can get trained in machine learning too.
 

Dear All,
I'm looking for a formula or a script that help me to :
First, split the dial code (caracter value ) from 8 digit to 1 in the file A, Second; perform a VLOOKUP on the File B of these spliter fields.
Thanks.
Ahmed.
 

I have 30 million records in Idea and now i want to create pivot table and summarization based on certain fields but i am getting an error that it can not display more than 32K records. Please let me know the other way in idea (scripting etc) which might help me to analyse the information.

Dear All,
I would like to know if is it possible to add the name of the file imported by creating a new field in idea.
Thank you.