Quick way to rename variables in script for cloned tables?

[kkorynta]

Hi All,

Is there a quick way to rename all of the variables in a cloned table in the script editor?

This is how my script works currently:

Account:

LOAD Name, BillingState, Product_Class... etc

FROM Account_Table;

[Account Statistics]:

LOAD Name as AS_Name, BillingStreet as AS_BillingState, Product_Class as AS_Product_Class

RESIDENT Account;

Some of our tables have quite a few variables. Is there a way to do a LOAD * RESIDENT Table and prefix/append text to all of the variables to keep them from joining together?

[CELAMBARASAN · Accepted solution]

You can use

Qualify *;//to restrict joins

UnQualify fieldnames;//to alow join on particular fields

[kkorynta]

Celambarasan, you're my  hero! Thank you, this is awesome.

Account:

LOAD *

FROM [$(vQVDPath)Accounts.QVD](qvd);

Qualify *;

[Account Stats]:

LOAD *

Resident Account;