Set NULL in Script

[ivandrago]

Hi,

How do I set NULL in the script, I thought it was Null() but it does not seem to be that?

Thanks

[Anonymous]

Hi

try below,

=If(len(trim(OriginalTable))= 0, Null(), OriginalTable)

[bhaskar_sm · Accepted solution]

Hi,

Please find below script.

TableA:

LOAD Area,TableName, if(len(OriginalTable)= 0,Null(),OriginalTable) as OriginalTable;

LOAD * INLINE [

    Area, TableName, OriginalTable

    AS, StrikeAssignedSVDAlias, Dimension.dbo.dimServiceServDept

    AS, StrikeAssignedUserAlias, Dimension.dbo.dimServiceUser

    AS, StrikeSVDAlias, Dimension.dbo.dimServiceServDept

    AS, StrikeUserAlias, Dimension.dbo.dimServiceUser

    AS, AssignedServDeptAlias, Dimension.dbo.dimServiceServDept

    AS, AssignedUserAlias, Dimension.dbo.dimServiceUser

    AS, ServiceBuilding

    AS, ServiceInc

    AS, ServiceItem

    AS, dbo.ServiceStrike

    AS, dbo.ServiceSection

    AS, dbo.ServiceUser

    AS, LastAssignment

    AS, LoggingSVDAlias, Dimension.dbo.dimServiceServDept

    AS, ResolverGroupAlias, Dimension.dbo.dimServiceServDept

    AS, ResolvingUserAlias, Dimension.dbo.dimServiceUser

    AS, Dimension.dbo.dimServiceCsg

    AS, Dimension.dbo.dimServiceServDept

    AS, Dimension.dbo.dimServiceUser

];

Regards,

Bhasker