Set NULL in Script

ivandrago — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

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

Thanks

Re: Set NULL in Script

Anonymous — Thu, 10 May 2018 16:04:29 GMT

try below,

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

bhaskar_sm — Thu, 10 May 2018 16:25:53 GMT

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