Hola equipo,
Obtengo datos del archivo .json que se encuentra en mi sistema local.
Cada columna comienza con "Valor." , desea volver a dar un nuevo espacio a este texto.
Mi cadena de consulta como abajo
= Table.TransformColumnTypes(#"Valor expandido",{{"Nombre", escriba texto}, {"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.hosp_patients", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.hosp_patients", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.hosp_patients", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.hosp_patients", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.hosp_patients", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.hosp_patients", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.hosp_patients", {"Value.hosp_patients", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.hosp_patients", {"Value.hosp_patients", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.hosp_patients", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.hosp_patients", {"Value.hosp_patients", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.hosp_patients", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.hosp_patients", type number}, {"Value.weekly_icu_admissions", {"Value.icu_patients_per_million", type number}, {"Value.hosp_patients", Type number}, {"Value.hosp_patients_per_million", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.hosp_patients", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.hosp_patients", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.hosp_patients", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.hosp_patients", {"Value.hosp_patients", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.hosp_patients", {"Value.hosp_patients", type number}, {"Value.weekly_icu_admissions", type number}, {"Value.weekly_icu_admissions", type number}, Value.weekly_icu_admissions_per_million", número de tipo}, {"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}})
