Add file name to item number in bom

Is it possible to add the file name of a drawing to the item number in the BOM?

Something like this where column 'File-Item' has the file name and the item number in one column, but without typing everything.

Can this be done automatically using a BOM template, or is API the way to go for this (if so does anyone have code to do this?)

thx,

Frank

SolidworksBill Of Materials