Aliasing in Scripts

Lisa Callahan

How do you alias in Birst scripts? For example, I want to use the below script twice, once for email and once for telephone.

LEFT OUTER JOIN
SELECT
[Level(HCMEmployeeContact.HCMEmployeeContact).Contact Detail Email Address],
[Level(HCMEmployeeContact.HCMEmployeeContact).Contact Detail Telephone Subscriber Number],
[Level(HCMEmployeeContact.HCMEmployeeContact).Contact Method State],
[Level(HCMEmployeeContact.HCMEmployeeContact).Description]
FROM
[Level(HCMEmployeeContact.HCMEmployeeContact)]
ON [Level(HCMEmployeeHistory.HCMEmployeeHistory).Employee Key]=[Level(HCMEmployeeContact.HCMEmployeeContact).Employee Key]
AND [Level(HCMEmployeeHistory.HCMEmployeeHistory).Use For Work Email Key]=[Level(HCMEmployeeContact.HCMEmployeeContact).Employee Contact Key]
AND [Level(HCMEmployeeContact.HCMEmployeeContact).Contact Method State]='Email'

Diane McElhiney

@Lisa Callahan Birst does not support table alias. Although, if you repeat your SELECT (same table) with a different filter and the associated columns for the filter, it acts as a table alias.
And not sure if this separated data will be reused but might want to consider separate Scripted Sources for email and phone.
Also, you can look into the new Prep Source, add same source twice with filtering.