Displaying 2 results from an estimated 2 matches for "column2multi".
2008 Jul 12
1
Reading Multi-value data fields for descriptive analysis
...uestion with several checkboxes and a free-format write-in response. The individual values within the data field are separated with the two characters ";#". So, the data would be of the following format (in CSV form with column headers and a tilde as the field separator):
Column1single~Column2multi~Column3multi
a sample value~C2 a multi one;#C2 a multi two~C3 a multi one;#C3 a multi two;#C3 a free-form answer
The first approach that comes to mind is to explode the multi-value fields into unique bi-variate data columns and then assign a 0 or 1 to these new columns in each record based on whe...
2008 Jul 12
0
Reading Multi-value data fields for descriptive analysis (resend)
...uestion with several checkboxes and a free-format write-in response. The individual values within the data field are separated with the two characters ";#". So, the data would be of the following format (in CSV form with column headers and a tilde as the field separator):
Column1single~Column2multi~Column3multi
a sample value~C2 a multi one;#C2 a multi two~C3 a multi one;#C3 a multi two;#C3 a free-form answer
The first approach that comes to mind is to explode the multi-value fields into unique bi-variate data columns and then assign a 0 or 1 to these new columns in each record based on whe...