Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have three queries.
In these queries, you have same columns, but where clause is different.
I want that an expression selects the value from a specific query.
How do i do this?
Hi,
Please post queries,So can help.
Regards
Neetha
SELECT
Year
,Country
sales
FROM B
WHERE SalesDate = trunc(SYSDATE);
select Year
,Country
,Sales
From C
Hi ,
Can you elaborate on your requirement?
Yes,
I want to select the total sales for today.
Because i want this every 5 minutes, i have two queries.
The First ..... where SalesDate = trunc(SYSDATE) i load partial
the other once a day.
So i want to refer in a chart to the first query .... How can i involve this, that chart looks in first query.
SELECT
Year
,Country
sales,
'B' as Source
FROM B
WHERE conditionB;
SELECT
Year
,Country
sales,
'C' as Source
FROM C
WHERE conditionC;
Use the source field in your expressions to calculate only with records loaded from a specific source.
Hope this helps
Regards
Marco
=Sum( ....,SOURCE={"A"} >} SALES )
IS THIS CORRECT ADDED? THE SOURCE?
Hi,
Further to marco's solution:
SELECT
Year
,Country
sales,
'B' as Source
FROM B
WHERE conditionB;
SELECT
Year
,Country
sales,
'C' as Source
FROM C
WHERE conditionC;
use below syntax in chart expresion:
=Sum({<source = {'B'}>},sales)
Regards
Neetha
when i use that, nothing more works
Better is using UNIQUE Column Names