Discussion Board for collaboration related to Creating Analytics for QlikView.
I have table "dbo.ACTION" which is found in my database "HN_PRODUCTION"
However, we have just created a new database "HN_BACKUP" but now the table are as follows:
The issue is that I have to load only the last three months.
To resume I have to load the below tables:
>dbo.ACTION which is HN_PRODUCTION
I managed to load the table using the script below:
Date(Floor(ActionLocalTime)) AS Date,
AgentId as FirstAgent,
Campaign as CampaignId,
Duration as DurationPre,
SQL SELECT *
FROM "HN_PRODUCTION".dbo.ACTION where NextState='96';
FOR Each a in '2015_12','2015_11','2015_10','2016_01'
FROM "HN_BACKUP".dbo.ACTION_$(b) where NextState='96';
HOWEVER, for next month a new table will be created in "HN_BACKUP" as "dbo.ACTION_2016_02" and I will need to load the data of the tables below:
I have around 35 qvw using these table.
Any idea on how to I can do it.
Go to Solution.
May be like:
for each fle in
try like below
for each fle in '2015_12','2015_11','2015_10','2016_01'
select * from dbo.ACTION_$(fle);
Can I make te below dynamic so that it calculate the last 3 months?