Daim duab qhia lub rooj hauv qlikview yog dab tsi?
Daim duab qhia lub rooj hauv qlikview yog dab tsi?

Video: Daim duab qhia lub rooj hauv qlikview yog dab tsi?

Video: Daim duab qhia lub rooj hauv qlikview yog dab tsi?
Video: Qhia txhais 50 zaj npau suav tias yog dab tsi part 3 15 Sep 2019 2024, Tej zaum
Anonim

QlikView - Daim duab duab . Kev tshaj tawm. Daim duab qhia yog a rooj , uas yog tsim rau daim ntawv qhia kab ntawv qhov tseem ceeb ntawm ob rooj . Nws tseem hu ua Lookup rooj , uas tsuas yog siv los nrhiav tus nqi cuam tshuam los ntawm lwm tus rooj.

Hauv qhov no, daim ntawv qhia load QlikView yog dab tsi?

Daim ntawv qhia rooj los yog Daim ntawv qhia load ua hauj lwm raws li ib qho kev xaiv rau Join nqe lus nyob rau hauv lub database. Daim ntawv qhia mus rau thauj nqe lus qhia Qlikview tias ib lub rooj yog Mapped nrog lwm tus. 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.

Qhov thib ob, pes tsawg daim teb nyob rau hauv 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.

Kuj nug, dab tsi yog thov daim ntawv qhia hauv QlikView?

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. Cov lus qhia, qhov tshwm sim ntawm uas yuav tsum tau mapped. default_mapping. 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.

Cov lus txuas hauv QlikView yog dab tsi?

Txuas lub rooj yog siv rau hauv cov ntaub ntawv qauv thaum koj muaj ntau qhov tseeb rooj tuav. Lwm txoj hauv kev los daws ntau qhov tseeb rooj yog concatenate, yog li koj tuaj yeem pom qee qhov tshaj tawm ntawm link table vs concatenate, Concatenate lossis Link Table ? Pib nrog kev txhim kho qlik ib cov qauv.

Pom zoo: