This content has been marked as final. Show 4 replies
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)?
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!