Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am currently using this in my load scripts but would like to pull just the MAX Snapshot date??
WHERE([SNAPSHOT_CCYYMM])>='201701'
May be this
WHERE [SNAPSHOT_CCYYMM] >= '201701';
Может быть, как это
WHERE [SNAPSHOT_CCYYMM] = Max (Date (Date# ([SNAPSHOT_CCYYMM], 'YYYYММ')));
May be like this
Table:
LOAD ....,
[SNAPSHOT_CCYYMM]
FROM ....;
Right Join (Table)
LOAD Max([SNAPSHOT_CCYYMM]) as [SNAPSHOT_CCYYMM]
Resident Table;