Question:
Is there possibility to combine the queries based on the keys.
I knew this can be done using Multi Provider (or) consolidation.
we want it done at query level
thanks
Raj
Answer:
As you suggest you can combine data using a multiprovider (data union), but queries can't be combined, unless you want to show results side by side in a web template. Queries can however produce a single key result which is used as an input (filter) into another query via a formula (known as a pre-query).
Answer:
Hi ,
Thanks for reply.
In the Web Templates i can display them side by side with single selection screen.
But these 2 tables have seperate scorll bars , its screwing me up.
I want to merge the these two tables in Web Template , thats what only the soultioni i knew as of now.
Please advice.
Thanks
Raj