Forum Discussion
Transpose columns from 1 table and create a new table
Hi, I have t able with 30+ columns in and I want to create another table with 3 columns from the original table then transpose 8 other columns into 1 column + a value column. The 8 columns I wan...
Possible to upload some sample/dummy data with the expected output?
Hi,
this is some sample data
new_growthhubreferralid _new_growthhub_value createdon unable_alreadyreferred unable_businessclosed unable_businessincrisis unable_camefromGH unable_customerdeclined unable_not eligible unable_notinterested unable_signposted new_ghrbusinessage new_ghrbusinessagemeetshubrequirements new_ghrbusinessclosed new_ghrbusinessplanning new_ghrdirectlyrequestedcontactwithgrowthhub new_ghrcapitalequipmentpurchase new_ghrgrowthpotential new_ghrlookingtocompletestafftraining new_ghrlookingtoexport new_ghrlookingtorecruitstaff new_ghrmeetsectorspecificrequirements _new_case_value 6141476d-bd39-e911-a8be-00224801a32d 4aec0216-f3fe-e811-a8db-00224801ac12 26/02/2019 11:55 FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE c9801ac1-3439-e911-a8d9-00224801a6b7 1ba970cc-d439-e911-a8e6-00224801a4ba 54ec0216-f3fe-e811-a8db-00224801ac12 26/02/2019 14:43 FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE 01bf2adb-c439-e911-a8d9-00224801a6b7 86702954-7b3a-e911-a8e6-00224801a4ba 54ec0216-f3fe-e811-a8db-00224801ac12 27/02/2019 10:35 FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE 06df1c7b-e139-e911-a8e7-00224801ae66 and this is how i need it to transpose to
_new_growthhub_value createdon Not referred Reason Count 4aec0216-f3fe-e811-a8db-00224801ac12 26/02/2019 11:55 unable_alreadyreferred 2 54ec0216-f3fe-e811-a8db-00224801ac12 26/02/2019 14:43 unable_businessclosed 3 54ec0216-f3fe-e811-a8db-00224801ac12 27/02/2019 10:35 unable_businessincrisis 5 68ec0216-f3fe-e811-a8db-00224801ac12 27/02/2019 13:44 unable_camefromGH 7 8aec0216-f3fe-e811-a8db-00224801ac12 27/02/2019 14:04 unable_customerdeclined 9 64ec0216-f3fe-e811-a8db-00224801ac12 27/02/2019 14:47 unable_not eligible 10 8eec0216-f3fe-e811-a8db-00224801ac12 27/02/2019 16:36 unable_notinterested 11 7aec0216-f3fe-e811-a8db-00224801ac12 27/02/2019 16:57 unable_signposted 12 80ec0216-f3fe-e811-a8db-00224801ac12 27/02/2019 17:23 unable_alreadyreferred 2 6aec0216-f3fe-e811-a8db-00224801ac12 27/02/2019 17:27 unable_businessclosed 3 7aec0216-f3fe-e811-a8db-00224801ac12 27/02/2019 17:35 unable_businessincrisis 5 7aec0216-f3fe-e811-a8db-00224801ac12 27/02/2019 17:51 unable_camefromGH 7 7aec0216-f3fe-e811-a8db-00224801ac12 27/02/2019 17:52 unable_customerdeclined 9 68ec0216-f3fe-e811-a8db-00224801ac12 28/02/2019 09:14 unable_not eligible 10 64ec0216-f3fe-e811-a8db-00224801ac12 28/02/2019 09:47 unable_notinterested 11 7aec0216-f3fe-e811-a8db-00224801ac12 28/02/2019 10:28 unable_signposted 12 Thanks
Debra
