Script help

[#1]

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?

[MayilVahanan]

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.