Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to replace multiple column names

Hi Team,

Am get data from .json file which is located in my local system.

Each column start with "Value." , want to repace this text.

 

My query string like bellow

 

= Table.TransformColumnTypes(#"Expanded Value",{{"Name", type text}, {"Value.continent", type text}, {"Value.location", type text}, {"Value.last_updated_date", type date}, {"Value.total_cases", Int64.Type}, {"Value.new_cases", Int64.Type}, {"Value.new_cases_smoothed", type number}, {"Value.total_deaths", Int64.Type}, {"Value.new_deaths", Int64.Type}, {"Value.new_deaths_smoothed", type number}, {"Value.total_cases_per_million", type number}, {"Value.new_cases_per_million", type number}, {"Value.new_cases_smoothed_per_million", type number}, {"Value.total_deaths_per_million", type number}, {"Value.new_deaths_per_million", type number}, {"Value.new_deaths_smoothed_per_million", type number}, {"Value.reproduction_rate", type number}, {"Value.icu_patients", Int64.Type}, {"Value.icu_patients_per_million", type number}, {"Value.hosp_patients", Int64.Type}, {"Value.hosp_patients_per_million", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.weekly_icu_admissions_per_million", type number}, {"Value.weekly_hosp_admissions", type number}, {"Value.weekly_hosp_admissions_per_million", type number}, {"Value.new_tests", Int64.Type}, {"Value.total_tests", Int64.Type}, {"Value.total_tests_per_thousand", type number}, {"Value.new_tests_per_thousand", type number}, {"Value.new_tests_smoothed", Int64.Type}, {"Value.new_tests_smoothed_per_thousand", type number}, {"Value.positive_rate", type number}, {"Value.tests_per_case", type number}, {"Value.tests_units", type text}, {"Value.total_vaccinations", Int64.Type}, {"Value.people_vaccinated", Int64.Type}, {"Value.people_fully_vaccinated", Int64.Type}, {"Value.total_boosters", Int64.Type}, {"Value.new_vaccinations", Int64.Type}, {"Value.new_vaccinations_smoothed", Int64.Type}, {"Value.total_vaccinations_per_hundred", type number}, {"Value.people_vaccinated_per_hundred", type number}, {"Value.people_fully_vaccinated_per_hundred", type number}, {"Value.total_boosters_per_hundred", type number}, {"Value.new_vaccinations_smoothed_per_million", Int64.Type}, {"Value.stringency_index", type number}, {"Value.population", Int64.Type}, {"Value.population_density", type number}, {"Value.median_age", type number}, {"Value.aged_65_older", type number}, {"Value.aged_70_older", type number}, {"Value.gdp_per_capita", type number}, {"Value.extreme_poverty", type number}, {"Value.cardiovasc_death_rate", type number}, {"Value.diabetes_prevalence", type number}, {"Value.female_smokers", type number}, {"Value.male_smokers", type number}, {"Value.handwashing_facilities", type number}, {"Value.hospital_beds_per_thousand", type number}, {"Value.life_expectancy", type number}, {"Value.human_development_index", type number}, {"Value.excess_mortality", type any}})

1 Reply