Script help

Mon, 02 Jul 2012 19:14:42 GMT

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 — Mon, 02 Jul 2012 19:25:41 GMT

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.