x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 5 replies
  • Answers 1 answer
  • Subscribers 17 subscribers
  • Views 1599 views
  • Users 0 members are here
Browse Forums
Announcements
237
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
210
topics
416
replies
Sage Intelligence Reporting
121
topics
322
replies
Ramya Chilamkuri

Query Tool to export data from different tables in excel format

SUGGESTED
Posted By

Hi,

I am using query tool to look at the data in ITMMASTER, ITMSALES,ITMBPS and ITMBPC tables using EXCEL sheet. Below is the screen shot of the fields that I want to use to get the data.

But I keep receiving this error when I try to validate.

Could someone help me understand the Query tool and How to make it work please.

Thank you!

Parents
  • 0

    Sometimes with this, I also find that adding new indexes to the tables help! if you need to link of fields that doesn't specifically match an index, none of the requestors like it (except SQL ofc where you create your own). The best fix seems to be to go create the indexes in the table definitions under development. 

Reply
  • 0

    Sometimes with this, I also find that adding new indexes to the tables help! if you need to link of fields that doesn't specifically match an index, none of the requestors like it (except SQL ofc where you create your own). The best fix seems to be to go create the indexes in the table definitions under development. 

Children
No Data

*Community Hub is the new name for Sage City