LOAD * and modify a certain field at the same time

[pennetzdorfer]

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!

[giakoum]

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

[pennetzdorfer]

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 * ...

[giakoum]

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!

[pennetzdorfer]

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

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