topic Re: Loading inline using autogenerate in QlikView

Loading inline using autogenerate

harleen_singh — Mon, 01 Aug 2011 11:24:54 GMT

I am using following script is it not correct??

LOAD * inline

[ CustomerID, PersonID AUTOGENERATE 1

WHILE PersonID<1699;

]

I want output like this

30028 1490

30029 1491

' '

' 1698

Regards

Lavi

Re: Loading inline using autogenerate

Miguel_Angel_Baeyens — Mon, 01 Aug 2011 11:32:05 GMT

Hello Lavi,

INLINE is used when you need hardcoded values for your fields. My guess is that the AUTOGENERATE table is enough to fit your needs, and will look like the following piece of script

Table:
LOAD RowNo() + 30000 AS CustomerID,
     RowNo() + 1000 AS PersonID
AUTOGENERATE 300;

So you will have a tabl

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Loading inline using autogenerate

harleen_singh — Mon, 01 Aug 2011 11:52:36 GMT

Miguel,

thanks for response the problem is i have customer ID and Person ID data before 30028 and 1490

and

after 1698(personID)

but i don't have data between these two range i.e 1490 and 1698(PersonID).

so i want to load that data between 1490 and 1698 and concatenate with other table that is Customer having CustomerID and PersonID.

thanks

Lavi

Re: Loading inline using autogenerate

Miguel_Angel_Baeyens — Mon, 01 Aug 2011 12:02:01 GMT

Hi,

Depending on the data model, you can load INLINE what you already have, and concatenate an AUTOGENERATEd table calculating what you want to get, for example

Table: // This is what you already have

LOAD * INLINE [

CustomerID, PersonID

30028, 1490

30029, 1698

];

// Here starts what you want to get.

// No need to specify CONCATENATE keyword since it will automatically concatenate if number and name of fields are the same

LOAD '' AS CustomerID,

1490 + IterNo() AS PersonID

AUTOGENERATE 1 WHILE 1490 + IterNo() < 1698;

Hope that gives you an idea on how to get it.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Loading inline using autogenerate

harleen_singh — Tue, 02 Aug 2011 06:18:13 GMT

Miguel,

The first code u give was helpful. but conacatenation was not working automatically so

finally it worked.

LOAD RowNo() + 30027 as CustomerID,

RowNo() + 1489 as PersonID

AUTOGENERATE 210;

Concatenate

LOAD CustomerID,

PersonID

FROM

Table

So if i want to Autogenerate incrementing by +2 then what should i write??

Regards

Lavi

Re: Loading inline using autogenerate

Miguel_Angel_Baeyens — Wed, 03 Aug 2011 07:34:16 GMT

Hello Lavi,

Check the following example:

Table:
LOAD * INLINE [
CustomerID, PersonID
30028, 1490
30029, 1698
];
CONCATENATE LOAD 30027 + (RecNo() * 2) AS CustomerID,
           1489 + (RecNo() * 2) AS PersonID
AUTOGENERATE 210;

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica