MAX() IN SCRIPT

[Chishndz]

Hello

when i use the max() function in the script below:

VBRP:
LOAD
División_VBRP,
MAX(FECHA) AS MAX_FECHA,
SKU,
1
Resident VBRP_TEMP
Where
NOT MATCH (SKU, '121', '122', '124', '127', '131', '132', '141', '142', '144', '145', '146', '148', '152', '154', '171')
AND MATCH (División_VBRP, 'PC01', 'PT01', 'PA01', 'PM01', 'PR01', 'PQ01', 'PF01', 'PF00', 'PM02')
Group BY SKU

generate an error: Invalid expression

[lironbaram · Accepted solution]

hi 

when running group by 

all field must have on of two conditons:

1. calculated in aggregated function

2. be part of the group by clause 

so in your case 

LOAD
División_VBRP,
MAX(FECHA) AS MAX_FECHA,
SKU,
1
Resident VBRP_TEMP
Where
NOT MATCH (SKU, '121', '122', '124', '127', '131', '132', '141', '142', '144', '145', '146', '148', '152', '154', '171')
AND MATCH (División_VBRP, 'PC01', 'PT01', 'PA01', 'PM01', 'PR01', 'PQ01', 'PF01', 'PF00', 'PM02')
Group BY SKU,División_VBRP