topic Load table stand alone in QlikView

Load table stand alone

Mon, 27 Apr 2009 22:35:12 GMT

I am trying to load a table but I do not want Qlikview to try and create keys based on the field names.

Is there a way to do this in qlikview without having to change all of the field names?

Thanks

Marc

Mon, 27 Apr 2009 22:44:45 GMT

Marc,

See the use of 'qualify' to make Qlikview prefix all the fields for a table with the name of that table.

Regards,

Gordon

Mon, 27 Apr 2009 22:49:25 GMT

Try this:

Qualify *

Select * From table;

Unqualify *

Mon, 27 Apr 2009 22:57:56 GMT

Thanks that works..

Marc