Adding columns from A-11 CSV outputs to main CSV table?

[BinFZheng]

Related to this data output issue: https://github.com/GSA/touchpoints/issues/1595

For the TSA passenger screening survey - they download both their main CSV and the A-11 CSV. Afterward, they need to join the two tables so they can grab the columns from the A-11 CSV tables (1s and 0s for the individual driver statement).

• HISP does not have capacity/script to break out the driver column in the main CSV themselves
• So they do the joining themselves outside of Touchpoints - which adds an extra step
• This could be quite common with other low capacity team (i.e. they don't have data scientists nor management analyst who can do this for them).
• The current main CSV outputs assume that agencies can break out the driver columns themselves.

Question Touchpoints team -

• Do we want to add the separate driver columns to the main download?
• If we do it for TSA, we would do it for all agencies with A-11 surveys.

Let's chat on Thursday, Sept 5 to see if we want to go in a particular direction.

[BinFZheng]

Effectively - the ask: Can we and is it sensible to add the columns from Export A11-v2 Responses to CSV to the end of All Responses here? This would help TSA and other customers from having to join tables and/or write script to break out the categorical driver response col in All Responses into individual driver columns.

[ryanwoldatwork]

@BinFZheng - how about something like:

Add a new button

Combine standard form columns with A-11 v2 columns

--

I started with this, as to not impact the standard form .csv export code.

https://github.com/GSA/touchpoints/pull/1612