Concatenate after inline

[debmsarkar123]

Hi

Im trying to understand a code-

Material:
LOAD * INLINE [
A,B
]
;

concatenate (Material)
LOAD *,[Material Code] & ':'& num([S]) as A
Where not Exists(A,[Material Code] & ':'& num([S]));

LOAD 

B,

X,

Z

FROM
$(vDataFolder)Material.qvd]
(qvd) 

I wanted to ask whats the use of using inline load at the top of the code here?

[Or]

Presumably it is intended to allow the use of Where not Exists without losing QVD optimization.

Have a look at https://www.axisgroup.com/data-industry-insights-blog/optimized-qvd-loads-caveats-for-using-the-exis...