This content has been marked as final. Show 2 replies
I have a campaign whereby for each month a new table is created on my SQL database.
|Month||Table name in SQL database|
Now my problem is that I have created a QVW which pull data from the table 201508_XXXXXXXX and now the only way is to change the table in the load script every month.
Is there a way that I can do it dynamically.
Note that I have another table in my SQL database which link the table to the campaign id.
|Campaign ID||Table name in SQL database|
Any idea how i can proceed.