I have a question, we need to make some extractions for a project, I will try to explain what we want.
1. We have a log file that is being filled during the day and when file reach 100 MB, it is stored in a table (MySql) with an specific name, as you know, we get a lot of tables per day.
2. Otherwise we have a master table who has stored information of the tables with name and generation date.
I was thinking if I can extract each rowf rom master table using a date and with table name field look for the table which we need to extract the information.
Is that possible?
I was not cear?
I am starting with QlikView, any comment can help me.
Thank you very much for your attention.