Hi Andy, thanks for the reply.
Suppose I could establish an SQL DB, but that would add another layer of complexity in my process.
All of my ETL work is performed prior to loading into Sense, and so far I haven't seen if Sense has the same capability my ETL tool currently has (my largest data cube to date is over 65M lines from 123 different systems).
I ended up replicating my app, clearing the data in the Data loader editor, and re-establishing the links with the appropriate file types etc.
Seems to have worked okay, was hoping for a "on the fly" source switch..
Something like this...
Pass your type and settings in as variables.
IF vType='CSV' THEN
SET vFile = 'lib://Documents/CSV.csv';
SET vFileType='txt, codepage is 1252, embedded labels, delimiter is \t, msq';
ELSEIF vType='EXCEL' THEN
SET vFile = 'lib://Documents/Excel.xlsx';
SET vFileType='ooxml, embedded labels, table is Sheet1';
FROM [$(vFile)] ($(vFileType));
It worked for me.