Load a sub-set of data

[#1]

Hi, I'm a newby whjo needs some help!.

I'm loading a table of risk data, but I want to load an aditional sub-set of it as well.

So as well as the 'Risk Owner' field, I want to develop a seperate field of 'Active Risk Owner', only where the 'Risk Status' is 'Active'.

I've been trying to figure out how to do this in the load script using IF and THEN statements, to no sucesses.

If [Status] ='Active' Then [Risk Owner] as [Active Risk Owner],

Am I close??

Any suggestions??

[Colin-Albert · Accepted solution]

You can use If within the load statement.

RiskData:

Load

     Status,

     [Risk Owner],

     If([Status] ='Active' , [Risk Owner]) as [Active Risk Owner],

     ....

[#3]

Try this,

if([Status] ='Active',[Risk Owner]) as [Active Risk Owner]

[#4]

Thanks Colin - i wasn't that far off after all!

really appreciate your help

[#5]

Thanks for that - it works now!