topic Using Max Date in Load Scripts in QlikView

Using Max Date in Load Scripts

Anonymous — Tue, 30 May 2017 12:59:14 GMT

I am currently using this in my load scripts but would like to pull just the MAX Snapshot date??

WHERE([SNAPSHOT_CCYYMM])>='201701'

Anil_Babu_Samineni — Tue, 30 May 2017 13:00:42 GMT

May be this

WHERE [SNAPSHOT_CCYYMM] >= '201701';

ahaahaaha — Tue, 30 May 2017 13:04:51 GMT

Может быть, как это

WHERE [SNAPSHOT_CCYYMM] = Max (Date (Date# ([SNAPSHOT_CCYYMM], 'YYYYММ')));

sunny_talwar — Tue, 30 May 2017 13:36:57 GMT

May be like this

Table:

LOAD ....,

[SNAPSHOT_CCYYMM]

FROM ....;

Right Join (Table)

LOAD Max([SNAPSHOT_CCYYMM]) as [SNAPSHOT_CCYYMM]

Resident Table;