topic Re: LOAD * and modify a certain field at the same time in QlikView

LOAD * and modify a certain field at the same time

pennetzdorfer — Tue, 07 Aug 2012 12:47:18 GMT

Hey,

is there a neat way to LOAD * from a resident table and at the same time modify a certain field (without having to rename it)?

Example:

LOAD *, 
       if(peek(InvoiceNo) = InvoiceNo, 'cancelled', InvoiceNo) as InvoiceNo
resident Invoices order by InvoiceNo asc, date desc)

My attempt gives an error "Field names must be unique within table" ... which is obvious, as the field 'InvoiceNo' already exists in the resident table.

Thanks for your ideas!

Re: LOAD * and modify a certain field at the same time

giakoum — Tue, 07 Aug 2012 12:51:02 GMT

replace the star * with the remaining field names and it should work.

Re: LOAD * and modify a certain field at the same time

pennetzdorfer — Tue, 07 Aug 2012 12:55:11 GMT

Thanks for your suggestion!

There are about 30 remaining fields - and in terms of keeping my script lean and "easy-care" I would prefer the star * ...

Re: LOAD * and modify a certain field at the same time

giakoum — Tue, 07 Aug 2012 13:01:07 GMT

Well then inner join it with itself or use a different field name, drop the original and rename the different to the original. Otherwise,.. I dont know!

Re: LOAD * and modify a certain field at the same time

pennetzdorfer — Wed, 08 Aug 2012 13:31:23 GMT

Yes, that's how I handle it at the moment.

I was just asking myself if there was a shorter/neater solution. Thanks anyway!