Hi, I am very new to programming and would like to know how i can use data being entered into edit input boxes in my code.
jeremycheong1993
Offline
Last seen: 1 year 11 months ago
Joined: 03/08/2018 - 20:39
Hi Jeremy, you might want to watch this video to help you out. https://www.youtube.com/watch?v=KpaJCx72OO8&t=227s
Thank you Brian for your reply! I certaintly have learnt quite alot!
Let me know if you have any questions and I will try and help you out.
Actually yes Brian i do,
I was wondering if it is possible to extract fields that i upload which are not part of the idea interface or user input.
Cheers! :D
Hi Jeremy,
I am not sure I understand what you are looking for. Can you give an example and I will try and help you out. When you talk about extract fields do you mean extracting fields from one database and placing them in another database?
Brian
Hi Brian,
I guess the right term is that I am trying to do a v lookup between 2 databases. I do not know how to code such a thing.
Example:Database A has field 1,2,3
Database B has field 1
Desired result: Database B has field 1,2 and 3
Thanks for the help!
Jeremy.
Hi Jeremy,
Sounds like you want to perform a join. CaseWare Analytics has a video on this (https://www.youtube.com/watch?v=xv_PaGW9_9Y&index=12&list=PLEE1l8LoXUCLS...)
Select the join function, since you want to add the fields from Database A to Database B, Database B would be your primary file and Database A would be your secondary file. Your match would be field1 as they are the commen field between the two databases. For the type of join I would probably recommend All Primary Recrords as this will return all records even if they don't have a corresponding transaction in Database A.
Let me know if you have any problems.
Brian
Once you've done as Brian has recommended, go to the History tab and you can copy the IDEAScript Code from that join to add to your code.
Also if you're joining more than one database try the visual connector - just discovered this myself. So much easier.