Change Fieldname Shown in Search Object Dropdown

[#1]

Hi

I've created some search objects with list of selected fields.  In the dropdown they are displayed as table.field.  How can I lose the table name from the dropdown and also can I change the fieldname at the same time here (if not I can change it in the load script)?

Cheers

Geoff

[er_mohit]

to change fieldname try

unqualify;

load

data as newdta

here data is my field name..

and write above unqualify if that fieldname comes with your tablename.fieldname

hope it helps

[#3]

Hi

So I guess you're saying that I'll need to do take aout the table name in the load script.

Do you mean like this:-

Table1:

UNQUALIFY;

LOAD
     Field1,
     Field2;
SQL SELECT
     Field1,
     Field2
FROM Table1

QUALIFY;

[er_mohit]

no.you write in  this way:

UNQUALIFY * ;

Table1:

LOAD
     Field1,
     Field2;
SQL SELECT
     Field1,
     Field2
FROM Table1

hope it helps

[#5]

Hi

Unfortunatley this breaks joins later in the load and it's a large fact type table so will need a lot of re-writting (if it's possible without breaking it altogether). Hence I was hoping to find some way to do it post load.

Cheers

Geoff