This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
Currently I have two tables M_InoutLine and M_MatchInv. Both have M_InoutLine_ID and i want to load rows from M_InoutLine that doesnt exist in M_MatchInv. I have tried this script but to no avail
m_inoutline.m_inout_id as m_inout_id,
m_inoutline.m_product_id as m_product_id,
m_inoutline.movementqty as movementqty,
m_inoutline.c_orderline_id as c_orderline_id
LOAD m_inoutline_id as m_matchinv.m_inoutline_id,
where not exists([m_matchinv.m_inoutline_id],m_inoutline_id);
Any help would be greatly appreciated
If you switch the order of loading of the two tables you can test for a match or no-match:
FROM [m_inoutline.qvd] (qvd);
Not( Exists( m_matchinv , m_inoutline_id ));
In your original code it seems like you have an Exists clause that will not work. I think it should look like this:
where not(exists( m_matchinv_id,m_inoutline_id));
View solution in original post
Thankyou , it actually works.
Do you mind to elaborate on why if i change the order of loading two tables would have different result?
Was it because on the first field that is evaluated by EXISTS evaluates all fields above it/ loaded before?
Exists use as the first parameter an in-memory field and check against all the values that has already been loaded into that field against the single value of the second parameter for the current row being loaded.
Got it Petter, thanks a lot or your help.