Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I've this load statement with a field defined by an expression as follow:
LOAD
....
if(field_a='some_value' AND field_b='some_value', 1, 0) as new_field
This load statament fetch data from a QVD.
I need to add another condition like this:
AND field_c='some_value'
where field_c belongs to __another table__ (inside the DB this table is joined with the source table of the previous QVD).
This data will be showed in a graph and field to be defined is used as an expression.
I can insert the new condition inside the expression of the graph instead to put it in the field definition of the load statement?
In both cases how can I refer the field of the other table?
Therefore, due to the huge amount of record (several milion) how that table should be loaded?
Thanks in advance!
Some point i am not able to catch but yes try loading the table with this huge data and follow this document to make Optimized dashboards.
Firstly join these two tables and then use resident load, in which you can put aal conditions.......
Thanks for your reply.
The pourpose is to define a field as an expression whose element belongs to different table.
I did something like the following:
QUALIFY "field_A1", "field_A2", "field_B1";
T1:
LOAD "field_ID",
"field_A1",
"field_A2",
FROM A.qvd (qvd);
inner join
T2:
LOAD
"field_ID",
"field_B1",
FROM B.qvd (qvd);
T3:
LOAD
"field_ID",
// some selection
T1.field_A1,
T1.field_A2,
T2.field_B1,
//
if((T1.field_A2)='test_value', 1, 0) As ZZZ // this is the field i try to define..
Resident T1
.. moreover the table T1 is very huge...
is this solution correct???