1 Reply Latest reply: Jul 2, 2012 3:25 PM by mayilvahanan ramasamy RSS

    Script help

      So heres what I'm trying to do.

       

      I have two fields, Group Description and Lean_Projects. They were were in two separate tables but I left joined them together.

       

      So when I make a table I want Lean_Projects to display either 'Lean' or 'Non Lean' depending on the value of Group Description.

       

      Sometimes Lean_projects is null as well, so that would have to change as well.

       

      Any ideas?

        • Re: Script help
          mayilvahanan ramasamy

          Hi,

           

           

               Try this,

           

               Load If(IsNull(Lean_Projects),'ZeroLean', Lean_Projects) as Lean ,*

                    from FileName.FileExtension

           

               When you left join the tables, please make sure, both table have common field name.

           

               Hope it helps.