Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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