I have 4 Input Data sets.
31-01-2022
28-02-2022
31-03-2022
30-04-2022
02-05-2022
I have (PROD ID , PROD STATUS, PROD STATUS DATE) in all workbooks and sheets but also the schema is different in all workbooks)
( here I'm trying to bring different workbooks with different schema) but i wanted to bring only the Date sheet in all the workbooks.
The Product Lifecycle status are defined below.
1.Draft
2.Design
3.Development
4.Implemented
PROD STATUS DATE is date field which represents the actual date of the PROD STATUS.
Logic
- First of i want to combine all the sheets with different schema.
- Secondly i want to find all the PROD ID that have a PROD STATUS = 4. Implemented and
- i want to Identify the WHERE The PROD STATUS = 4. Implemented take those Product and identify
- How long these 4.Implemented Products where at
1.Draft to 2.Design (No.of Days)
2.Design to 3.Development (No.of Days)
3.Development to 4.Implemented (No.of Days)
and finally Overall from 1.Draft to 4.Implemented (No.of Days)
Thanks
