Combining fields into one field

[khaycock]

I have the following bit of my script that I was hoping to be able to combine into one big field rather than split it up into 7 different ones.

Can I make the results of these combine into one field that is called ControlReporting and it spits out the same 'Not Reporting' and 'Is Reporting' results? 

if(date(today())-15 >= ControlSCCM, 'Not Reporting', 'Is Reporting') AS SCCMReporting,
if(date(today())-15 >= ControlEpo, 'Not Reporting', 'Is Reporting') AS EPOReporting,
if(date(today())-15 >= ControlQRadar, 'Not Reporting', 'Is Reporting') AS QRadarReporting,
if(date(today())-15 >= ControlTenable, 'Not Reporting', 'Is Reporting') AS TenableReporting,
if(date(today())-15 >= ControlCredant, 'Not Reporting', 'Is Reporting') AS CredantReporting,
if(date(today())-15 >= ControlERPM, 'Not Reporting', 'Is Reporting') AS ERPMReporting,
if(date(today())-15 >= ControlCyberark, 'Not Reporting', 'Is Reporting') AS CyberarkReporting

[vvira1316]

Hi,

I'm not sure if you were expecting as following

if(date(today())-15 >= ControlSCCM, 'Not Reporting', 'Is Reporting') AS ControlReporting,
if(date(today())-15 >= ControlEpo, 'Not Reporting', 'Is Reporting') AS ControlReporting,
if(date(today())-15 >= ControlQRadar, 'Not Reporting', 'Is Reporting') AS ControlReporting,
if(date(today())-15 >= ControlTenable, 'Not Reporting', 'Is Reporting') AS ControlReporting,
if(date(today())-15 >= ControlCredant, 'Not Reporting', 'Is Reporting') AS ControlReporting,
if(date(today())-15 >= ControlERPM, 'Not Reporting', 'Is Reporting') AS ControlReporting,
if(date(today())-15 >= ControlCyberark, 'Not Reporting', 'Is Reporting') AS ControlReporting,

Above is not correct as you can't have same field names.

So not sure why you are expecting it to be one  field. It will be helpful if you will share sample data, script and explain your requirements in more detail.