Combine Multiple Fields in Load Script from Excel ... - Qlik Community

Anonymous · ‎2016-02-17

Hi All,

I am working with a Qualtrcis output that gives me several fields that should all be considered the same. In excel they are all different columns. I want to load each as the same field in the load script. I included an example below. Question 1, 3 and 5 are should all be considered as the same, although worded different and the same can be said for 2 and 4. There are many other questions in the actual output, but only included several for reference. Any help is greatly appreciated.

1. [Performance Objectives Clinical-Documentation: Accurately documents patient care Seeks support and coaching for challenges],
2. [Performance Objectives Clinical-Adaptability: / / Applies knowledge, skills and right attitude to implement individualized plan of care /],
3. [Performance Objectives Non Clinical-Documentation: / / Accurately documents per department protocols / Seeks support and coaching for challenges or questions],
4. [Performance Objectives Non Clinical-Adaptability: / / Applies knowledge, skills and right attitude while performing job responsibilities /],
5. [Please rate the clinician on the following performance objectives:-Documentation: / <ul> / <li>Accurately documents patient care into the KPHC system in a timely manner.</li> / <li>Seeks support and coaching re KPHC challenges or barriers.</li> / </ul> /],

Best regards.

Combine Multiple Fields in Load Script from Excel Doc