Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

changing the name of all column names without QUALIFY statement

Hi,

I am pulling in multiple tables that are not related. but they share many common column names that are identical.

but not only for the purpose of disconnecting the table but also to be able to instantly see from which table each variables came from, i want to concatenate the name of the table in front of each variables.

is there any simple ways to do that?

thank you in advance!!

8 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

QUALIFY is the book answer for everything you described in your requirements. Some developers don't like using QUALIFY in complex script, so the alternative is to manually rename each field in the script. It is more explicit, however it requires a lot more keystrokes.

cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy and Austin, TX!

avinashelite

As per my knowledge QUALIFY is the only easy way to do that , otherwise you need to rename each field manually

Not applicable
Author

Hi David,

If you don't want to use QUALIFY, the simple method is to use "as" after the ColumnName and rename it as TableName.ColumnName.

But QUALIFY will be a better option.

Regards,

Rohan

Not applicable
Author

Hi David

If you don't want to use qualify statement  in the script then you should change manually every field by aliasing statement in the script  it takes time for that .But the best way to do thing faster You should Use Qualify Statement in the script for faster Result.

So just check this example of Explanation about Qualify Statement

Do you Qualify?- How to use QUALIFY statement

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this using using Rename Fields using

FieldMap:

Mapping SQL SELECT oldnames, newnames

FROM datadictionary;

Rename fields using FieldMap;

You can maintain old and new names in an Excel, database or in Inline table.

Hope this helps you.

Regards,

jagan.

ramasaisaksoft

Hi David,

How many columns you have in Script?

-->if those are less columns try to do rename with  "as" keyword

-->Qualify & Un qualify

-->copy all columns from table and modify easily in Excel with your wish and then Load the same columns using by Resident load

engishfaque
Specialist III
Specialist III

Dear David,

Listed below are the ways through which you can rename the fields,

1. using AS specifier

2. using Alias statement

3. using Rename Field/Table statement

4. Qualify statement

Kind regards,

Ishfaque Ahmed

Not applicable
Author

Hi David

other way is to alias the column names using AS.