I use the left keep to hone down a table to only relevant data to certain field. I am not joining or adding anything to the table, almost like data reduction. See the attachment. Good Luck
KEEP.txt 888 bytes
Consider an example:
LOAD * INLINE [
Left keep (Test1)
Load * Inline [
Please refer the application for above example and check the result by using left join and left keep.
Leftkeep_LeftJoin_diff.qvw 145.0 K