Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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}})
Solved! Go to Solution.
Allí, @BaluChalla
Pruebe los siguientes pasos:
1. Usa encabezados como primera fila
2.Transponer este cuadro
3.Reemplazar valor
4. Transponga esta tabla y use la primera fila como encabezados
Saludos
Equipo de soporte de la comunidad _ Eason
Allí, @BaluChalla
Pruebe los siguientes pasos:
1. Usa encabezados como primera fila
2.Transponer este cuadro
3.Reemplazar valor
4. Transponga esta tabla y use la primera fila como encabezados
Saludos
Equipo de soporte de la comunidad _ Eason