Skip to main content
Question

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

  • September 16, 2019
  • 0 replies
  • 74 views
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 displaying the corresponding value in the Reconciliation table onto a specific column. I have tried to apply the API_DoQuery which gives no errors but doesn't write the data into the other table. Please assist! Here is the function i have applied which doesn't include the field ID of the column to display the data. I have tried using the IF statement formula but i have no option to import from another table.

<qdbapi>
<usertoken>%user.token.b4s2ci_jdr8_brbx.VenFloat%</usertoken>
<apptoken>app_token</apptoken>
<udata>mydata</udata>
<query>{'7'.EX.'_FID_6'}AND{'27'.EX.'_FID_16'}</query>
</qdbapi>

------------------------------
Daniel Othwolo
------------------------------
This topic has been closed for replies.

  • AustinK
  • Registered
  • September 16, 2019
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.
Terms & ConditionsAccessibility statement