topic Help in QlikView

Help

nagarjuna_kotha — Mon, 18 May 2015 09:13:57 GMT

Hi All,

I have extracted data from MySQL ,after loading data from Databade i got some synthatic keys i need renamed it to avoid those sythatic keys.But what i want is i dont want to rename it my script i want it in database itself.How to do that?

Can anyone help me on this.....

Its Urgent>>>>>>>>>>>>>>>>>.

Regards

Nag

Re: Help

Mon, 18 May 2015 09:30:36 GMT

Try something like this

ALTER TABLE "table_name" CHANGE "old_column_name" "new_column_name" DATATYPE;

But this will change your database in SQL, so not something to be done lightly.

Re: Help

MayilVahanan — Mon, 18 May 2015 09:33:25 GMT

If you need to change the name in database itself. You need to have rights for that.

sql - How to rename a table column in MySQL - Stack Overflow

Or, you can rename in qv itself.