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?

[#2]

Hi Pradeep,

I tried your solution but it didnt worked.

Im also finding that if any one have the solution

[tresesco]

Not possible natively in qv, you can try extension, see: "Better Current Selections Box" with support to hide/translate fields

And vote for similar idea: Field translation in "Current Selections"

[Anonymous · Accepted solution]

Try loading the second column with a space after 'NTA'

For example :

LOAD NTA as [NTA ]