Is there a function accepted in OTBI to print FIRST ROW of values? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is there a function accepted in OTBI to print FIRST ROW of values?

in Reporting and Analytics for SCM

Summary:

Summary:

I would like to Print all Invited Suppliers and selected Sites with site adress and site email but if Contact is blank in Negociation, only print first contact from the list of contacts in Supplier profile.

I used Copilot to optimize script and it added ROW_NUMBER() function to rank the contacts and then filter to keep only the first one which resulted in error in the Issue SQL;

It also tried MIN function that also resulted in error.

So is there a function accepted in OTBI to print FIRST ROW of values?

Content (please ensure you mask any confidential information):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!