Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am hoping someone can please help with the below requirement.
The life-cycle of a document has multiple versions, with varying Revision Letters (also can be numeric or alpha-numeric).
- In the example below, the first two VERSIONS are REVISON 'A'. This is the first revision letter (based on created date) so i would like them to be a 1.
- The Third VERSION is REVISION B, so I would like this to be a 2
- The forth VERSION is an A, so I would like it to be a 1
- and the 5th VERSION is a B so i would like it to be a 2.
Thanks in advance
Ben
Perhaps it's an issue of the example being too simplistic, but it seems like in this case it would be solved by using:
Ord(Revision)-64
Thanks Or for the Prompt response but unfortunately it will not work. Our customer specifies the revision sequence, so we could have various sequences i.e.
Thanks
Ben
Hi All,
We can achieve desired out put by
Left Join (Main_Table)
Load Distinct
Document#&Revision As PrimaryKey
Autonumber(Document#&Revision, Document#) As DesiredOutPut
Resident Main_Table;