splitpatterns col: {Major_code,Major,Major_category,Total,Employed,Employed_full_time_year_round,Unemployed,Unemployment_rate,Median,P25th,P75th} type: on on: ',' limit: 10
rename type: manual mapping: [{Major_code,Major,Major_category,Total,Employed,Employed_full_time_year_round,Unemployed,Unemployment_rate,Median,P25th,P75th1},'Major_code']
rename type: manual mapping: [{Major_code,Major,Major_category,Total,Employed,Employed_full_time_year_round,Unemployed,Unemployment_rate,Median,P25th,P75th2},'Major']
rename type: manual mapping: [{Major_code,Major,Major_category,Total,Employed,Employed_full_time_year_round,Unemployed,Unemployment_rate,Median,P25th,P75th3},'Major_category']
rename type: manual mapping: [{Major_code,Major,Major_category,Total,Employed,Employed_full_time_year_round,Unemployed,Unemployment_rate,Median,P25th,P75th4},'Total']
rename type: manual mapping: [{Major_code,Major,Major_category,Total,Employed,Employed_full_time_year_round,Unemployed,Unemployment_rate,Median,P25th,P75th5},'Employed']
rename type: manual mapping: [{Major_code,Major,Major_category,Total,Employed,Employed_full_time_year_round,Unemployed,Unemployment_rate,Median,P25th,P75th6},'Employed_full_time_year_round']
rename type: manual mapping: [{Major_code,Major,Major_category,Total,Employed,Employed_full_time_year_round,Unemployed,Unemployment_rate,Median,P25th,P75th7},'Unemployed']
rename type: manual mapping: [{Major_code,Major,Major_category,Total,Employed,Employed_full_time_year_round,Unemployed,Unemployment_rate,Median,P25th,P75th9},'Median']
rename type: manual mapping: [{Major_code,Major,Major_category,Total,Employed,Employed_full_time_year_round,Unemployed,Unemployment_rate,Median,P25th,P75th10},'P25th']
rename type: manual mapping: [{Major_code,Major,Major_category,Total,Employed,Employed_full_time_year_round,Unemployed,Unemployment_rate,Median,P25th,P75th11},'P75th']
rename type: manual mapping: [{Major_code,Major,Major_category,Total,Employed,Employed_full_time_year_round,Unemployed,Unemployment_rate,Median,P25th,P75th8},'Unemployment_rate']
filter type: not col: Major not: 'Major' action: Keep
derive type: single value: CEILING(Employed / Total * 100) as: 'Percentage_Employed'
filter type: greaterThan col: Percentage_Employed greaterThan: 80 greaterThanEqual: true action: Keep
sort order: -Percentage_Employed
move col: Percentage_Employed position: after after: P75th