topic Load data from multiple table which is having common fields in QlikView

Load data from multiple table which is having common fields

shanmurugesh — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I'm facing one challenging problem while making data model.

the scenario is...

In our database, PLC system will store all the parameters of machine as one table for every day.

ie one new table will be created on 01/04/2016 as MAC_PARAM_010416,similarly for each day system will create one new table as MAC_PARAM_(DATE).

Now i needs to load the data from these table in to qvd on daily basis , with the simple script.

Hope you guys can give ideas.

Thanks and regards,

Murugesan.

Re: Load data from multiple table which is having common fields

perumal_41 — Sat, 12 Nov 2016 07:44:56 GMT

use like below

Let vToday=Date(today-1,'DDMMYY'

MAC_PARAM_$(vToday):

Load * From MAC_PARAM_$(vToday);

Store MAC_PARAM_$(vToday) into MAC_PARAM_$(vToday).qvd;

Drop table MAC_PARAM_$(vToday)

Re: Load data from multiple table which is having common fields

maxgro — Sat, 12 Nov 2016 11:19:20 GMT

read and store in qvd 1 year of files in loop

FOR i=0 to -365 step -1

LET vDate = Date(Today() +i, 'DDMMYY');

trace $(vDate);

// change with your file name

SourceTable:

load * from .......; // use vDate variable

store * from SourceTable into .......qvd (qvd); // "

NEXT

read all your 2016 files with wildcard (* ?)

LOAD * from MAC_PARAM_????16.csv;

Re: Load data from multiple table which is having common fields

shanmurugesh — Thu, 17 Nov 2016 09:20:22 GMT

Hi Massimo,

thanks ..it is working fine.

I have one more scenario like this..hope u can give some idea

there are few tables are newly generated in each day with some predefined prefix in my database.

ie, new tables are created in the name of "AVAIL_XXXXX"

in that XXXXX may be any in name..

in our previous scenario we have date filed in the tablename to filter our tables.

but in this current scenario, how can i identify which are all the tables are not loaded to my qvd??

thank you.

Re: Load data from multiple table which is having common fields

perumal_41 — Thu, 17 Nov 2016 09:42:51 GMT

try like below ,may be help to you

AVAIL:

Load * From AVAIL_*;

Store AVAIL into AVAIL.qvd;

Drop table AVAIL

Re: Load data from multiple table which is having common fields

shanmurugesh — Thu, 17 Nov 2016 09:46:45 GMT

it is working fine, but on the next day i should only load which are all the tables are not loaded in the previous day, how can i identify those tables from database?

is there any option to check with directory??

thank you

Re: Load data from multiple table which is having common fields

perumal_41 — Thu, 17 Nov 2016 15:37:54 GMT

Yes. is possible .

Let me know what is your type (excel,notepad,xml)?

Re: Load data from multiple table which is having common fields

MarcoWedel — Thu, 17 Nov 2016 23:01:21 GMT

please close your thread if your initial question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco

Re: Load data from multiple table which is having common fields

sudhir0538 — Sat, 17 Mar 2018 14:00:14 GMT

Hello Marco Great job really very helpful.

Can u just check this and see if you can help me out ! Badly needs support.

Compare with Old Data