topic Re: generic load tables in QlikView

generic load tables

samuel_brierley — Tue, 01 Sep 2015 07:44:03 GMT

Hi all,

I really am at a loss here,

I have the following load;

Data:
generic LOAD timestamp#(Time) as Timestamp ,
Date(left(Time,9),'DD/MM/yyyy') as Date,
Time(Right(Time,5),'hh:mm') as Time,'M56_J4_Eastbound' as Site,
Type,
Name,
Value

FROM XXX

This results in about 20 different tables e.g Data.Common

the above is funnily enough a data log of which I get one a day, so when I load in the next days how do I concatenate into the correct tables?

this will then allow me to store as QVD's.

hope that makes atleast some sense.

Re: generic load tables

lironbaram — Tue, 01 Sep 2015 07:47:52 GMT

why do you need generic load in this case

why do you want to split the table to different table for each field

Re: generic load tables

samuel_brierley — Tue, 01 Sep 2015 07:52:21 GMT

because the field names are stored as field values in one column (Name), while the

field values are stored in a second(Value).

Re: generic load tables

qlikviewwizard — Tue, 01 Sep 2015 07:55:02 GMT

Hi Samuel,

Please go through these links. Hope this will help you.

Thank you.

The Generic Load

Generic Load (A Manufacturing Example)

Generic Load Joining

Generic Load

Re: generic load tables

samuel_brierley — Tue, 01 Sep 2015 08:03:39 GMT

Thanks QlikView Wizard, unfortunately i'm only a desktop user so I can open the documents

could you please convert the following script so that its correct that would be great thanks,

Data:

generic LOAD timestamp#(Time) as Timestamp ,
Date(left(Time,9),'DD/MM/yyyy') as Date,
Time(Right(Time,5),'hh:mm') as Time,'M56_J4_Eastbound' as Site,
Type,
Name,
Value

FROM Day1.csv

Data:

generic LOAD timestamp#(Time) as Timestamp ,
Date(left(Time,9),'DD/MM/yyyy') as Date,
Time(Right(Time,5),'hh:mm') as Time,'M56_J4_Eastbound' as Site,
Type,
Name,
Value

FROM Day2.csv

as an example the below are examples of 2 of the tables created when the script for Day1 is run, all I want to do is add the stuff from Day2 to these tables.

Data.CommonParameters.Group.oCr

Data.CommonParameters.Group.qDes

obviously there are more tables and days but im sure I can work it out once I get started

thanks

Re: generic load tables

lironbaram — Tue, 01 Sep 2015 08:17:30 GMT

if your load statement for each day creates exactly the same tables with the same columns structure

then qlikview will automatically merge the data from the different dates

you don't need to do anything

Re: generic load tables

jonathandienst — Tue, 01 Sep 2015 08:30:24 GMT

Those links are to blog postings which explain how to use Generic loads. They are not to qvw files. I suggest that you read those articles - especially the first.