Condition is not working in Load script

[#1]

Hi All,

Please find the attached Qvw and Data file.

I have a condition in data load script where

if([WBS Element]<>null(),[WBS Element],if(Len(Assignment)>=6,Assignment,H.Text)) as WBS_Code_Final

If the data in WBS Element field is empty then it should check for Assignment field. If the length of assignment field is >=6 it should take that value otherwise H.Test as the WBS_Final_code.

If the data is not null in WBS Element then WBS Element should be take as WBS_Code_Final.

Please let me know if you need any clarifications.

Regards,

Keerthi KS

[Kushal_Chawda · Accepted solution]

Please see the attached.

[robert_mika]

if(len(trim([WBS Element]))>0,[WBS Element],if(Len(Assignment)>=6,Assignment,H.Text)) as WBS_Code_Final

[#4]

Thanks a lot

[jonathandienst]

You cant compare nulls like that. Use:

if(Not(IsNull([WBS Element])), [WBS Element], if(Len(Assignment) >= 6, Assignment, H.Text)) as WBS_Code_Final