Input Id. Date 1. 200701 1 200701 1 200702 2 201001 2 201002 2. 201002 Need output where in flag has 1 for both duplicate rows Output Id Date flag 1. 200701. 1 1 200701. 1 1 200702. 0 2 201001. 0 2 201002. 1 2. 201002. 1
... View more
Period unique id. Flag 201208. 1. Open 201208. 2. Closed 201209. 3. Closed 201210. 4 Default 201211. 5. Open Need results like ( number of account) Period. Open. Closed. Default 201208. 1. 1 0 Similarly for other dates
... View more
Table 1. Newkey period 1. 201701 2. 201701 3. 201701 1. 201801 Table 2 Newkey. Period 1. 201701 2. 201701 1. 201801 Compare two tables and find out accounts(newkey) which are unique or not present in another table on each period.
... View more
Help me find solutions for below problem Date. Newkey. Flag Dec16. 13. 0 Jan17. 13. 1 Feb17. 13. 1 Mar17. 13. 1 Need to find total cases as to how many times the flag switched from 0 to 1 in above table
... View more
