0 Replies Latest reply: Jan 18, 2018 2:58 PM by Qlik Rambo RSS

    applymap function

    Qlik Rambo

      hi Team

      one of my requirement says to bring a new field into the existing table .

      so i used applymap to bring the new field, I did like shown below,

       

      Fac_Fee_map:

      Mapping

      LOAD facility_id,

           FMSPrePaymentFee

      FROM $(vQVDPath)fac_fee.qvd (qvd);

       

      ApplyMap('Fac_Fee_map',FMSFacilityID, null()) as FMSPrePaymentFee,

       

       

      but i see difference in the facilityID's, i want to get all the facility Id's data, can anyone suggest me how to do that?