Hi All, I have below data where my Report_Date data type is Date. UserIDCostCenterReport_Date100A10015-01-2021100B10019-01-2021100C10031-01-2021200A20025-01-2021200B20031-01-2021300A30001-02-2021300B30011-02-2021300C30021-02-2021300D30026-02-2021 My expected output is to generate the multiple rows by incrementing the report by 1 on group level of user id and cost center. If in my first row Userid is 100 , cost center is A100 and report date 15-01-2021 then my new row generation would be 16-01-2021, 17-01-2021 and so on till 18-01-2021 i.e. next cost center and report date change for same user id. In above case report date is changed on 19-01-2021. So next incremental entry should be based on new cost center i.e. B100 and Report Date 19-01-2021 till next report date. It means my output would be as below UserIDCostCenterReport_Date100A10015-01-2021100A10016-01-2021100A10017-01-2021100A10018-01-2021100B10019-01-2021100B10020-01-2021100B10021-01-2021100B10022-01-2021100B10023-01-2021100B10024-01-2021100B10025-01-2021100B10026-01-2021100B10027-01-2021100B10028-01-2021100B10029-01-2021100B10030-01-2021100C10031-01-2021200A20025-01-2021200A20026-01-2021200A20027-01-2021200A20028-01-2021200A20029-01-2021200A20030-01-2021200B20031-01-2021300A30001-02-2021300A30002-02-2021300A30003-02-2021300A30004-02-2021300A30005-02-2021300A30006-02-2021300A30007-02-2021300A30008-02-2021300A30009-02-2021300A30010-02-2021300B30011-02-2021300B30012-02-2021300B30013-02-2021300B30014-02-2021300B30015-02-2021300B30016-02-2021300B30017-02-2021300B30018-02-2021300B30019-02-2021300B30020-02-2021300C30021-02-2021300C30022-02-2021300C30023-02-2021300C30024-02-2021300C30025-02-2021300D30026-02-2021 Thank you in advance.

generate the row based on condition

Hi All,

I have below data where my Report_Date data type is Date.

UserID	CostCenter	Report_Date
100	A100	15-01-2021
100	B100	19-01-2021
100	C100	31-01-2021
200	A200	25-01-2021
200	B200	31-01-2021
300	A300	01-02-2021
300	B300	11-02-2021
300	C300	21-02-2021
300	D300	26-02-2021

My expected output is to generate the multiple rows by incrementing the report by 1 on group level of user id and cost center.

If in my first row Userid is 100 , cost center is A100 and report date 15-01-2021 then my new row generation would be 16-01-2021, 17-01-2021 and so on till 18-01-2021 i.e. next cost center and report date change for same user id. In above case report date is changed on 19-01-2021. So next incremental entry should be based on new cost center i.e. B100 and Report Date 19-01-2021 till next report date.

It means my output would be as below

UserID	CostCenter	Report_Date
100	A100	15-01-2021
100	A100	16-01-2021
100	A100	17-01-2021
100	A100	18-01-2021
100	B100	19-01-2021
100	B100	20-01-2021
100	B100	21-01-2021
100	B100	22-01-2021
100	B100	23-01-2021
100	B100	24-01-2021
100	B100	25-01-2021
100	B100	26-01-2021
100	B100	27-01-2021
100	B100	28-01-2021
100	B100	29-01-2021
100	B100	30-01-2021
100	C100	31-01-2021
200	A200	25-01-2021
200	A200	26-01-2021
200	A200	27-01-2021
200	A200	28-01-2021
200	A200	29-01-2021
200	A200	30-01-2021
200	B200	31-01-2021
300	A300	01-02-2021
300	A300	02-02-2021
300	A300	03-02-2021
300	A300	04-02-2021
300	A300	05-02-2021
300	A300	06-02-2021
300	A300	07-02-2021
300	A300	08-02-2021
300	A300	09-02-2021
300	A300	10-02-2021
300	B300	11-02-2021
300	B300	12-02-2021
300	B300	13-02-2021
300	B300	14-02-2021
300	B300	15-02-2021
300	B300	16-02-2021
300	B300	17-02-2021
300	B300	18-02-2021
300	B300	19-02-2021
300	B300	20-02-2021
300	C300	21-02-2021
300	C300	22-02-2021
300	C300	23-02-2021
300	C300	24-02-2021
300	C300	25-02-2021
300	D300	26-02-2021