topic Re: Doubts about renaming all fields in a table in QlikView

Doubts about renaming all fields in a table

Thu, 23 Oct 2014 12:55:31 GMT

Hi everybody. I have qualified tables (i´ve imported it from QVDs) and i wanna rename all. I should use AS with all but i´m guessin if there is another option. I cant use qualify because... here is the table

LOAD A.asignado,

A.cotiza,

A.cotizacion,

A.precioKairos,

A.precioVenta,

A.precioCosto,

A.precioPresupuestos,

A.lab,

etc...

there is some function for this?

Thank you all!

Re: Doubts about renaming all fields in a table

alexandros17 — Thu, 23 Oct 2014 13:06:59 GMT

I think no ...

Re: Doubts about renaming all fields in a table

salto — Thu, 23 Oct 2014 13:07:58 GMT

Hola,

I think this post can be very helpful: the third option can be the one you are looking for.

http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/25/how-to-rename-fields

Hope this helps!

Re: Doubts about renaming all fields in a table

Thu, 23 Oct 2014 13:08:18 GMT

Ok thank you. It is bad to the performance to have a lot of AS??

Re: Doubts about renaming all fields in a table

alexandros17 — Thu, 23 Oct 2014 13:18:18 GMT

No, performance decrease with if or where conditions