Renaming Columns of a Dynamic Table

prees959 — Thu, 24 May 2018 14:40:37 GMT

Hi.

Im looping through a sql connection that dynamically names certain columns of a table with each pass so each time the 4th, 5th and 6th columns have a different name depending on the contents....

Is there a way I can rename, for example, the 4th, 5th, 6th columns of this table dynamically?

Many thanks

Phil

Re: Renaming Columns of a Dynamic Table

marcus_sommer — Fri, 25 May 2018 07:51:32 GMT

Within the load itself it's not possible but you could change them afterwards maybe with something like this:

for i = 4 to 6

let FieldName = fieldname($(i), tablename(nooftables()));

rename field $(FieldName) to FieldXYZ;

Of course you need also some logic to define the right name to the right field - and you couldn't change it to an already existing fieldname (if this is needed you need some more logic).

Also a reverse approach is possible by creating a load-statement on the fly by loading the first record from the table, looping through all fieldnames and creating with them a load-string including some logic to replace the wrong fieldnames with the right ones - an then applying this load-string to the real load.

- Marcus

topic Renaming Columns of a Dynamic Table in QlikView

Renaming Columns of a Dynamic Table

Re: Renaming Columns of a Dynamic Table