Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to merge three reports in one application, Which displayed as worksheets in that one application. Lets call it X,Y,Z reports . In X reports I need to display all the projects with PSP _ELEMENT but in report Y I only need to display project with limited number of projects which holds some conditions like where where "PSP_ELEMENT" like '%-BZ-%' OR "PSP_ELEMENT" like '%-BZ%'. I want to ask how to write query in Data load editior in such a way that one worksheets display all the projects and another reports will display projects with some conditions
Not sure if I understand the problem, but you can combine different data sets originated from different queries. Something like:
MyTable:
SQL SELECT * FROM TableA WHERE Z = Y .....;
Concatenate(MyTable)
SQL SELECT * FROM TableB WHERE A = ''some search' OR .....;
Concatenate(MyTable)
SQL SELECT * FROM TableC WHERE Some other condition .....;
Not sure if I understand the problem, but you can combine different data sets originated from different queries. Something like:
MyTable:
SQL SELECT * FROM TableA WHERE Z = Y .....;
Concatenate(MyTable)
SQL SELECT * FROM TableB WHERE A = ''some search' OR .....;
Concatenate(MyTable)
SQL SELECT * FROM TableC WHERE Some other condition .....;