Data Preview in Script View showing different results than var_out on DEBUG mode

[Former Member]

Hi experts,

Here is the scenario, I have developed a script in a HANA script view and when I run the debug my var_out variable shows all the correct records, but when I select the semantics node and click on Data preview it's aggregating some ids and eliminating some others.

var_out = SELECT WHSE, ID, SCORE, KPI, 1 AS "COUNT" FROM :IT_OUTPUT;

Debug - VAR_OUT - Record count 156,257

Applying filters in ID = 122483 and 11653098

Data Preview - Record count 155,754

Applying filters in ID = 122483 and 11653098

Please advice.

Thanks in advance

Héctor