Latest version filters

ranibosch — Mon, 19 Mar 2018 13:56:22 GMT

Good day,

please see my excel spreadsheet attached with fields and the required results.

I'm unsure on how to write the script to get the latest version of a BOM header.

Re: Latest version filters

niclaz79 — Mon, 19 Mar 2018 14:54:01 GMT

Hi,

Temp:

LOAD

[Production BOM Version.Description],

[Production BOM Version.Version Code]

FROM

[FileName and Sheetname etc]

where

[Production BOM Version.Status] = 1;

Temp2:

LOAD

Max([Production BOM Version.Version Code]) as MaxVersion

Resident Temp;

let vMaxVersion = Peek('MaxVersion',0,'Temp2');

drop table Temp2;

ProductionBOM:

LOAD

[Production BOM Version.Description]

Resident Temp

where [Production BOM Version.Version Code] = $(vMaxVersion);

drop table Temp;