Column headers concatenation

[monish_chandra]

Hi,

I'm trying to create a separate column which stores the concatenated string of column headers which has a value. It should not consider in the string if there is a 0 or null value. I've added the 'EXPECTED_RESULT' column to show how it should look like. I tried to use the transpose and cross tab tool. But looks like my data is already in a cross tab format. How can create the last column in the below table?

ID	DESCRIPTION	CODE	HOSP1	HOSP2	HOSP3	HOSP4	EXPECTED_RESULT
1	ACETOMINOPHIN	S4657	0	10	20	50	HOSP2,HOSP3,HOSP4
2	TYLENOL	H3456	23			56	HOSP1,HOSP4
3	IODEXNOL	A4657	2		1	0	HOSP1,HOSP3

[Morgan_Thomas · Accepted solution]

Hello, 

I've attached a solution I think will work. let me know what you think.

Thanks!
Morgan