Union and Data formatting

[jay_viz]

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

[gautiergodard]

Hey @jay_viz 

Is the attached what you are trying to do? 

The input files in your workflow are not coming through as they were not packaged. To package a workflow, go to Option -> Export Workflow

Hope this helps!

[jay_viz]

@gautiergodard  Input is slightly different, I have attached the workflow as package now. Thank you

[binuacs]

@jay_viz You need to use join tool then union

[jay_viz]

@binuacs Thanks, Is there a way to achieve the second format

[binuacs · Accepted solution]

@jay_viz add the transpose tool and configure like below for the second format