Hello,
Considering today's date - 7th March 2020, then i need that yesterday's date (i.e. 7th march 2020 minus 1 = 6th march 2020) data should come in my output file
Input file: -
Product ID | Product Name | 1st level Approval status | 1st level Date | 2nd level Approval status | 2nd level Date | 2nd level Approval status | 3rd level Date |
12345 | M | In Transmit | 12/13/19 | Submitted | 12/13/19 | Rejected | 03/06/20 |
23456 | N | In Issue | 10/19/19 | Submitted | 10/19/19 | Submitted | 03/06/20 |
98766 | Z | Accepted | 12/13/19 | In Issue | 03/06/20 | In Issue | 12/13/19 |
45678 | A | Accepted | 11/25/19 | Accepted | 11/25/19 | Accepted | 11/25/19 |
32156 | B | Accepted | 12/13/19 | Rejected | 12/13/19 | Accepted | 03/06/20 |
23457 | C | Rejected | 03/06/20 | May get Rejected | 03/06/20 | May get Rejected | 12/12/19 |
45678 | W | Submitted | 12/11/19 | In Transmit | 12/11/19 | Rejected | 12/11/19 |
12980 | X | Accepted | 12/11/19 | Accepted | 12/11/19 | Accepted | 12/11/19 |
45987 | Y | Rejected | 12/01/19 | Submitted | 12/01/19 | Submitted | 03/06/20 |
345678 | Z | May get Rejected | 12/11/19 | Accepted | 12/11/19 | Accepted | 03/06/20 |
234568 | Q | In Issue | 03/06/20 | Submitted | 10/27/19 | Submitted | 10/27/19 |
98765 | s | Accepted | 12/13/19 | Rejected | 12/13/19 | In Transmit | 12/13/19 |
output file data required:
Product ID | Product Name | 1st level Approval status | 1st level Date | 2nd level Approval status | 2nd level Date | 2nd level Approval status | 3rd level Date |
12345 | M | In Transmit | 12/13/19 | Submitted | 12/13/19 | Rejected | 03/06/20 |
23456 | N | In Issue | 10/19/19 | Submitted | 10/19/19 | Submitted | 03/06/20 |
98766 | Z | Accepted | 12/13/19 | In Issue | 03/06/20 | In Issue | 12/13/19 |
32156 | B | Accepted | 12/13/19 | Rejected | 12/13/19 | Accepted | 03/06/20 |
23457 | C | Rejected | 03/06/20 | May get Rejected | 03/06/20 | May get Rejected | 12/12/19 |
45987 | Y | Rejected | 12/01/19 | Submitted | 12/01/19 | Submitted | 03/06/20 |
345678 | Z | May get Rejected | 12/11/19 | Accepted | 12/11/19 | Accepted | 03/06/20 |
234568 | Q | In Issue | 03/06/20 | Submitted | 10/27/19 | Submitted | 10/27/19 |
Solved! Go to Solution.
Hi @Rajeev18 I mocked up a workflow that produces your desired output. Let me know what you think?
@Rajeev18 - Here is my solution by just using date conversions (to convert date fields which are in string format to date formats ) and filters.