generic load tables

[samuel_brierley]

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.

[lironbaram]

hi

why do you need generic load in this case

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

[samuel_brierley]

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

field values are stored in a second(Value).

[qlikviewwizard]

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

[samuel_brierley]

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

[lironbaram · Accepted solution]

hi

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

[jonathandienst]

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.