Posachedwapa, tinakambirana za kugwiritsa ntchito FILTER.XML ntchito kuitanitsa deta ya XML kuchokera pa intaneti - ntchito yaikulu yomwe ntchitoyi, kwenikweni, ikufunira. M'njira, komabe, kugwiritsidwa ntchito kwina kosayembekezereka komanso kokongola kwa ntchitoyi kwawonekera - kugawa mwachangu mawu omata m'maselo.
Tiyerekeze kuti tili ndi gawo la data monga chonchi:
Zachidziwikire, kuti zikhale zosavuta, ndikufuna kuzigawa m'mizere yosiyana: dzina la kampani, mzinda, msewu, nyumba. Mutha kuchita izi m'njira zingapo:
- ntchito Zolemba ndi zigawo kuchokera ku tabu Deta (Deta - Zolemba mpaka mizati) ndi kupita masitepe atatu Wofotokozera mawu. Koma ngati deta isintha mawa, muyenera kubwereza ndondomeko yonse kachiwiri.
- Kwezani deta iyi mu Power Query ndikugawanitsa pamenepo, kenako ndikuyiyikanso ku pepala, kenako sinthani funsolo data ikasintha (zomwe zimakhala zosavuta kale).
- Ngati mukufuna kusintha pa ntchentche, ndiye kuti mutha kulemba mafomu ovuta kwambiri kuti mupeze ma comma ndikuchotsa mawu pakati pawo.
Ndipo mutha kuzichita mokongola kwambiri ndikugwiritsa ntchito FILTER.XML ntchito, koma ikukhudzana bwanji nazo?
Ntchito ya FILTER.XML imalandira ngati mtsutso wake woyamba nambala ya XML - zolemba zolembedwa ndi ma tag apadera ndi zikhumbo, ndikuzigawa m'zigawo zake, kuchotsa zidutswa za data zomwe timafunikira. Khodi ya XML nthawi zambiri imawoneka motere:
Mu XML, chinthu chilichonse cha data chiyenera kutsekedwa mu ma tag. Chizindikiro ndi mawu ena (m'chitsanzo pamwambapa ndi manejala, dzina, phindu) otsekeredwa m'mabokosi. Ma tag nthawi zonse amabwera awiriawiri - kutsegula ndi kutseka (ndi slash yowonjezeredwa pachiyambi).
Ntchito ya FILTER.XML imatha kuchotsa mosavuta zomwe zili m'ma tag onse omwe timafunikira, mwachitsanzo, mayina a oyang'anira onse, ndipo (chofunika kwambiri) awonetse onse nthawi imodzi pamndandanda umodzi. Chifukwa chake ntchito yathu ndikuwonjezera ma tag ku zolemba zoyambira, ndikuzisintha kukhala XML code yoyenera kusanthula kotsatira ndi ntchito ya FILTER.XML.
Ngati titenga adilesi yoyamba pamndandanda wathu monga chitsanzo, ndiye kuti tifunika kuyisintha kukhala yomanga iyi:
Ndinayitana kutsegulira kwapadziko lonse ndikutseka ma tag onse t, ndi ma tag omwe amapangira chinthu chilichonse ndi s., koma mutha kugwiritsa ntchito mayina ena aliwonse - zilibe kanthu.
Ngati tichotsa ma indents ndi mizere yopumira pa code iyi - kwathunthu, mwa njira, mwakufuna ndikuwonjezedwa kuti zimveke bwino, ndiye kuti zonsezi zidzasanduka mzere:
Ndipo itha kupezedwa kale mosavuta kuchokera ku adilesi yoyambira posintha ma comma ndi ma tag angapo. pogwiritsa ntchito WOLEMBEDWA (MALOWA) ndi kumamatira ndi chizindikiro & kumayambiriro ndi kumapeto kwa ma tag otsegulira ndi kutseka:
Kuti tiwonjezere zotsatira zake mopingasa, timagwiritsa ntchito ntchito yokhazikika Mtengo wa TRANSP (TRANSPOSE), kukulunga ndondomeko yathu mmenemo:
Chofunikira pamapangidwe onsewa ndikuti mu mtundu watsopano wa Office 2021 ndi Office 365 mothandizidwa ndi magulu osiyanasiyana, palibe manja apadera omwe amafunikira kuti mulowetse - ingolowetsani ndikudina Lowani - ndondomeko yokhayo imakhala ndi chiwerengero cha maselo omwe amafunikira ndipo chirichonse chimagwira ntchito ndi bang. M'matembenuzidwe am'mbuyomu, pomwe panalibe masanjidwe osinthika, muyenera kusankha ma cell okwanira okwanira musanalowe fomulo (mutha ndi malire), ndipo mutatha kupanga fomula, dinani njira yachidule ya kiyibodi. Ctrl+kosangalatsa+Lowanikuti mulowetse ngati ndondomeko yowonjezera.
Chinyengo chofananira chitha kugwiritsidwa ntchito polekanitsa mawu olumikizidwa mu selo imodzi kudutsa mzere:
Kusiyana kokha ndi chitsanzo cham'mbuyomu ndikuti m'malo mwa comma, apa tikusintha mawonekedwe osawoneka a Alt + Enter, omwe atha kufotokozedwa mu fomula pogwiritsa ntchito CHAR ndi code 10.
- Zobisika zogwirira ntchito ndikudumpha mizere (Alt + Enter) mu Excel
- Gawani zolemba pamizere mu Excel
- Kusintha mawu ndi SUBSTITUTE