topic Generate table key on LOAD in QlikView

Generate table key on LOAD

salto — Wed, 03 Nov 2010 08:07:15 GMT

Hello,

I am loading a SQL table that has no keys. It is not a problem in itself, but I would like to add a key field on load time (something simple, like an autonumeric field):

TableWithNoKeys:

LOAD MyAutomericFieldThatIdentifiesTheLoadedRecord,

field1, field2, ..., fieldN;
SQL SELECT *
FROM "Database".dbo."TableWithNoKeys";

Can I create such a field? Many thanks in advance.

Generate table key on LOAD

sparur — Wed, 03 Nov 2010 08:43:32 GMT

Hello, Salto

You could use RowNo() function for create incremental index for each row.

Like as:

LOAD Field1, Filed2, RowNo() as KeyLineNum

;

SQL SELECT,,,

See more details in reference manual or internal help system.

Generate table key on LOAD

salto — Wed, 03 Nov 2010 09:15:29 GMT

Perfect! Thank you.