Dab tsi yog daim ntawv qhia load thiab ApplyMap?
Dab tsi yog daim ntawv qhia load thiab ApplyMap?

Video: Dab tsi yog daim ntawv qhia load thiab ApplyMap?

Video: Dab tsi yog daim ntawv qhia load thiab ApplyMap?
Video: Leng Yang - Yog Vim Dab Tsi (Official Full Song | Nkauj Tawm Tshiab) 2020/05/24 2024, Hlis ntuj nqeg
Anonim

Nyob zoo, Tshawb xyuas qhov piv txwv no rau Mapping load thiab Apply Map muaj nuj nqi. Daim ntawv qhia load yog siv rau thauj tus daim ntawv qhia table qhov twg as Thov daim ntawv qhia yog siv rau daim ntawv qhia daim ntawv Mapped mus rau lwm lub rooj ntxiv saib cov piv txwv hauv qab no.

Tib neeg kuj nug, dab tsi yog daim ntawv qhia kev thauj khoom hauv qlik kev nkag siab?

Daim ntawv qhia mus rau thauj nqe lus qhia Qlikview tias ib lub rooj yog Mapped nrog lwm tus. A daim ntawv qhia lub rooj tuaj yeem muaj 2 kab - tus nqi nrhiav thiab cov daim ntawv qhia tus nqi. Daim ntawv qhia Cov ntxhuav yog cov ntxhuav ib ntus raws li lawv tau txiav tawm ntawm cov qauv ntaub ntawv los ntawm qhov kawg ntawm kev ua tiav ntawm tsab ntawv.

Kuj Paub, muaj pes tsawg daim teb nyob rau hauv ib daim ntawv qhia? QlikView Daim ntawv qhia Load Statement Feem ntau, a daim ntawv qhia muaj ob kab, thawj muaj qhov tseem ceeb rau kev sib piv (raws li qhov taw qhia siv) thiab thib ob uas muaj cov txiaj ntsig los yog qhov xav tau raws li qhov sib piv.

Tsuas yog li ntawd, daim ntawv thov yog dab tsi?

Cov ApplyMap script function yog siv rau daim ntawv qhia cov zis ntawm ib qho kev qhia mus rau ib tug yav tas los loaded daim ntawv qhia rooj. Yog hais tias, tus nqi no yuav raug siv los ua tus nqi pib yog tias tus daim ntawv qhia lub rooj tsis muaj qhov sib piv rau cov lus qhia. Yog tsis tau teev tseg, tus nqi ntawm kev qhia yuav raug xa rov qab raws li yog.

Dab tsi yog qhov kev siv Crosstable prefix hauv QlikView load tsab ntawv?

Crosstable . Cov crosstable ua ntej yog siv tig a hla rooj mus rau hauv ib lub rooj ncaj, uas yog, lub rooj dav dav nrog ntau kab yog hloov mus rau hauv lub rooj siab, nrog cov kab lus hauv kab lus tau muab tso rau hauv ib qho khoom siv ib sab. Cov teb uas muaj cov nqi tsim nyog. Cov teb uas muaj cov ntaub ntawv muaj nuj nqis.

Pom zoo: