hello all,
Is it possible to setup a query that has the source tables/fields as a variable?
Source Tables : They all have the same data but different field names
Position_1: Fields = Account; Value; Date
Position_2: Fields = Acct; Val; DT
Position_3: Fields = AcctNum; Acctval; AcctDate
Query Name = PosQ
Here is the scenario.
PosQ is setup to reference [Position_1]'s 3 fields.
At some point I need to point PosQ to [Position_2] - which has the same data but with different field names. I'll have a translation table that equates the PosQ fields with the Position_1, _2, _3 fields
This does not have to be run time setting, more like a fixed database-wide "Pointer" that will map the PosQ fields to the correct Position_1, _2, _3 table fields.
I don't know how to point the PosQ query to the different table to then let the translation table do its work.
Maybe this is a strange one.
Thanks for any help
Is it possible to setup a query that has the source tables/fields as a variable?
Source Tables : They all have the same data but different field names
Position_1: Fields = Account; Value; Date
Position_2: Fields = Acct; Val; DT
Position_3: Fields = AcctNum; Acctval; AcctDate
Query Name = PosQ
Here is the scenario.
PosQ is setup to reference [Position_1]'s 3 fields.
At some point I need to point PosQ to [Position_2] - which has the same data but with different field names. I'll have a translation table that equates the PosQ fields with the Position_1, _2, _3 fields
This does not have to be run time setting, more like a fixed database-wide "Pointer" that will map the PosQ fields to the correct Position_1, _2, _3 table fields.
I don't know how to point the PosQ query to the different table to then let the translation table do its work.
Maybe this is a strange one.
Thanks for any help