1 Reply Latest reply: Jul 2, 2012 3:25 PM by Mayil Vahanan 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
          Mayil Vahanan Ramasamy




               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.