Update column names in expression

[Anonymous]

Hello Experts,

For user convenience I am chaning Column name in script.

Is there anyway it will automatically replace old to new one in dimension and expressions of charts.

Thanks

Kiran

[hic · Accepted solution]

Because you change both name and load order. "Sales" is already loaded in the first table, whereas Sales_Update is loaded in the second.

HIC

[Anonymous]

Can we say this as limitation?

Thanks

Kiran

[hic]

No, it is rather a question about what is theoretically possible. In this case, there is no way for QlikView to “know” which field is which, without making an analysis of the field values before and after the script run. And this, QlikView doesn't do.

The logic is simple: If you keep the names the same, but change the order, e.g.

  A, B, C, D  -->  A, D, C, B

then it works. And if you keep the order and change one or several field names, e.g.

  A, B, C, D  -->  A, E, C, F

then it also works.

But if you make more complex changes, it doesn't work.

HIC