2 Replies Latest reply: Aug 26, 2014 8:23 AM by Jonathan Dienst RSS

    Field creation while data modelling

      Hello,

       

      I am having a trouble in getting correct data. I am having a Product name which consist of Coutry code and i want to categorised Product name with Country code. I am creating Coutry code field from Product Name field.

       

      After creating Coutry code field, i am having an issue. For example, If the Product name is NL SAP HANA, and i have created a Coutry code field from "NL SAP HANA" and after reload i am getting country name as NA rather than NL. I am having huge data to create Courty code field. Also country code can anywhere in the product name.

       

      Attached is the sample QVW.

      Regards,

      Imran K