Forum Discussion

Qrew Member

6 years ago

Comparison between two tables and display the outcome on one column using the API_DoQuery

Good Day I am an intern at an ISP assigned to develop a Reconciliation between bank deposits and the amount floated to vendors. I am having a problem with comparing the two different fields and dis...

APIs and custom code

Qrew Commander

6 years ago

DoQuery will only do a query that you choose and return data. It will return everything you ask it to and then you need to do something with that data.

After the DoQuery how are you handling the returned data?

If you are wanting to get data from one table and import it to another one you are likely wanting to use ImportFromCSV but that qill require the data to be in csv format.

DanielOthwolo
Qrew Member
6 years ago
Yes, I intend to import data into one table from a CSV file then map one column onto another table if the criteria are met using the ImportFromCSV. I did attempt to do that but the results don't seem to display on the other table. How can I add an IF Statement to compare records and add the data where the criteria is met?

------------------------------
Daniel Othwolo
------------------------------
- DanielOthwolo
  Qrew Member
  6 years ago
  Please help!!!!!
  
  ------------------------------
  Daniel Othwolo
  ------------------------------
  - AustinK
    Qrew Commander
    6 years ago
    Just so I understand a little better, do you have any code that you are already using? I'm not even 100% sure what you are doing from your explanation.
    
    One thing I was thinking is, do you need to do this via code or have you tried a native solution? If you need 2 tables data sent to a single table that is easy and you can then do whatever calculations or comparisons you want. You just need to use relationships and have the 2 tables be parents and have one child table where you lookup fields to. Unless I am misunderstanding what you are wanting to do here?