Hello,
I am trying to compare two sets of Excel data in the following format below. The first data set drives the other to main integration. However, with data set 2 the way that it is exported from its tool. It stacks the CA at one row and the WP are followed underneath it.
My end goal with this workflow is to group the CA with it's associated WP, but also insure that there is integration between the two data sets and that if there are any disconnects it would be highlighted. Below is also a screen shot of my current workflow build.
I used the "Select" functions to convert the vString in data set 1 and 2 to dates ( as well as rename the columns). I have tried using the "Join" function but since the format of data set 2 is not the same as Data set 1 that was unsuccessful. So using the Union function is what I thought would be the best since they are in somewhat a similar structure and just need to be further massaged.
Any help would be greatly appreciated.
Data set 1:
| CWBS | CA | WP | Baseline Start | Baseline Finish | Start | Finish |
| 1.1 | CA | | | | | |
| 1.1 | CA | ABC1 | 1/1/2019 | 2/28/2019 | 1/1/2019 | 2/28/2019 |
| 1.1 | CA | ABC2 | 2/1/2019 | 3/29/2019 | 2/1/2019 | 4/26/2019 |
| 1.1 | CA | ABC3 | 4/1/2019 | 3/4/2020 | 4/1/2019 | 3/4/2020 |
Data set 2:
| CA/WP | Description | Baseline Start | Baseline Finish | Forecast Start | Forecast Finish |
| CA | ABC | | | | |
| WP1 | ABC1 | 1/1/2019 | 2/28/2019 | 1/1/2019 | 2/28/2019 |
| WP2 | ABC2 | 2/1/2019 | 3/29/2019 | 2/1/2019 | 4/26/2019 |
| WP3 | ABC3 | 4/1/2019 | 3/20/2020 | 4/1/2019 | 3/4/2020 |
