Renaming of columns/fields for users

[#1]

Hi,

I have 2 separate data sets which are disjoint (I donot want to join them on any field).

But they have the same fields. Now to avoid JOINS I have renamed the fields, but I want to dispay the same name in Search Boxes and Current Selection Boxes.

For example - I have a column named NTA in both data sets and to avoid Joins I rename it to NTA1 in one data set.

When I create a 'Current Selection' Box I still want it to appear as NTA (instead of NTA1) for the user as that is the business description for that field.

How do I achieve it?

[selvakumarsr]

Try to use Qualify

Like this

QUALIFY;

One:

LOAD City

FROM

TestDel.xlsx

(ooxml, embedded labels, table is One);

QUALIFY;

Two:

LOAD City

FROM

TestDel.xlsx

(ooxml, embedded labels, table is Two);

Selva

[MayilVahanan]

Hi

Try with

NoConcatenate

[maleksafa]

i am not sure if you can do that, because if you want to do that you would have the rename both columns to the same name and then they will be joined, but in your case if you want them to be treated as one filed in the current selection box, why not joining them in your script and add another flag to distinguish between column 1 and 2.

[SunilChauhan]

there seems no option as of now. so might be its not possible .

try to  rename it as in script as required.

otherwise from front end we can't  do.

hope this helps

[SunilChauhan]

i dont  thing noconcatenate is a option for this .may be its create syn keys

please correct if am wrong

[PradeepReddy]

Try with 'NoConcatinate' option...

Sample script...

Customers_1:
Load * inline
[
CNo,CName
10,ABC
20,BCD
30,CDE
];

NoConcatenate

Customers_2:
Load * inline
[
CNo,CName
100,ABCD
200,BCDE
300,CDEF
];

If you execute the above script, synthetic keys will be formed. Check the results, wether the results are as expected or not..

Regards

Pradeep

[Anonymous]

Hi,

You may get help from blog created by Henric.

http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/25/how-to-rename-fields

Thanks

[MayilVahanan]

Hi Sunil

Yes its form synthetic key when there is more than one field with same name.

But i thought he has only one same field.

[#10]

Hi All

Thanks for all your suggestions. But can this be done w/o getting into synthetic keys ?