5 Replies Latest reply: Jul 24, 2012 5:27 PM by mayilvahanan ramasamy RSS

    Default Value Option in Inline

      Hi,

       

      I have below table which describe various grocery types-

       

      NameQtySeasonCountry of Origin
      Mango2SpringMexico
      Orange3All SeasonsUSA
      Apple4All SeasonsUSA
      Fig2WinterItaly
      Rice3SummerChina
      Peppers5All SeasonsJamaica

       

      I am creating inline table to attach field Type. I want to have Types as "Fruit","Crop" or "Unknown".

       

      Load * Inline

      [

      Name,Type

      Mango,Fruit

      Orange,Fruit

      Apple,Fruit

      Fig,Fruit

      Rice,Crop

      ]

       

      Now in above list I want to add a default option which will map any other 'Name" value as "Misc".

       

      Can you please suggest how to check it.