I have data from multiple inputs and trying to combine and format them so that I could use them in the Reporting. I tried to combine using union and it does not work the way I wanted.
We are looking at Transport and Healthcare availability in each state and then try to put 1 or 0 for each state based on if the feature is available. Final output I am looking for is in 2 different formats. I have attached the workflow I am building for this.
Format 1
| | Transport | Healthcare |
| OH | 0 | 1 |
| CA | 1 | 1 |
| NY | 1 | 1 |
| PA | 0 | 1 |
Format 2
| | Feature | Value |
| OH | Transport | 0 |
| OH | Healthcare | 1 |
| CA | Transport | 1 |
| CA | Healthcare | 1 |
| NY | Transport | 1 |
| NY | Healthcare | 1 |
| PA | Healthcare | 1 |
