changing the name of all column names without QUALIFY statement

[#1]

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!!

[Oleg_Troyansky]

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

[#4]

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

[#5]

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]

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]

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

[#9]

Hi David

other way is to alias the column names using AS.