Do you have the possibility of unioning your datasource to itself?
I (poorly) mocked up an example of a self union which generates
the field [Table Name] which can be used in calculations to differentiate,
like for date type:
IF [Table Name]="Sheet1" THEN [Load Date]
ELSE [Empty Date]
Please adjust the attached datasource to more closely match your setup,
and then please repost.
Workbook is v10.3, attached in the Forum Thread:
I'm attempting to use it as a live connection to a published data source or a Microsoft SQL Server stored procedure. It doesn't appear I can create unions with those sources.