Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
hi
why do you need generic load in this case
why do you want to split the table to different table for each field
because the field names are stored as field values in one column (Name), while the
field values are stored in a second(Value).
Hi Samuel,
Please go through these links. Hope this will help you.
Thank you.
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
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
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.