Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How do I set NULL in the script, I thought it was Null() but it does not seem to be that?
Thanks
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
Hi
try below,
=If(len(trim(OriginalTable))= 0, Null(), OriginalTable)
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