Qualify + Hide Prefix

[vikasmahajan]

Dear All,

I have campaign data with qualify fields  with  campaign Job Function i have used Set HidePrefix Command to  hide selected

fields but when i am selecting  campaign Job Function field , This field is visible in selection box . I don't want to show field is selected also i want to use qualify keyword.

Any one can help on this ?

Thanks in adv

Vikas

[jagan]

Hi,

It is not possible, you have to rename like below

QUALIFY *;

UNQUALIFY %CampaignId;

Campaign:

LOAD %CampaignCreatedById,

     %CampaignId,

     %CampaignJobFunction,

     %CampaignOwnerId,

     %CampaignQTCompany,

     [Campaign Annual Revenue Range],

     [Campaign Audience],

     [Campaign Count],

     [Campaign Created Date],

     [Campaign Data Source Category],

     [Campaign End Date],

     [Campaign End Date New],

     [Campaign Event Date],

     [Campaign Event End Date],

     [Campaign Event Start Date],

     [Campaign Group Employee Range],

     [Campaign Id],

     [Campaign Incentive],

     [Campaign Line of Business],

     [Campaign Objective],

     [Campaign Publishable Name],

     [Campaign Sector],

     [Campaign Start Date],

     [Campaign Start Date New],

     [Campaign Status],

     [Campaign Sub Type],

     [Campaign Type],

     Month,

     Quarter,

     Year

FROM

C:\Martin\Campaign.xls

(biff, embedded labels, table is Sheet1$);

RENAME FIELD Campaign.%CampaignJobFunction to %CampaignJobFunction;

OR

UNQUALIFY %CampaignId, %CampaignJobFunction;

Hope this helps you.

Regards,

jagan.

[vikasmahajan]

Thanks Jagan I tried using rename field it's working already  but  i have 30 tables in my data modeling

and I don't want to rename %CampaignJobFunction field  will  it  still possible to hide field in selection box ?

Thanks/

Vikas

[tresesco · Accepted solution]

Another way could be using Tag , like:

Tag Field Campaign.%CampaignJobFunction with '$Hidden';

[vikasmahajan]

Thanks Tresesco i will get back you.

[vikasmahajan]

First Reply workd  !! Tresesco

Thanks

Rename field NonPrdBkp.UpdateStatus to  %NonPrdBkp.%UpdateStatus;