topic Re: Renaming a string in columns in Visualization and Usability

Renaming a string in columns

Mon, 20 Feb 2017 12:06:57 GMT

Hi, please help me. I have a column as follows:

I need to rename it from 'inet' to 'resident', from 'static' to 'corporate' and from 'cvpn' to 'test'. How can I do this please? Thank you very much.

tcullinane — Mon, 20 Feb 2017 12:32:49 GMT

If this is a Field and not a calculated dimension then in your load script create a mapping table before you load the field.

Something like

APN_Map:

mapping

Load * inline [

mapfrom, mapto

inet, resident

static, corporate

cvpn, test

];

Then when you are loading the APN field use

applymap('APN_Map',APN) as APN

surendraj — Mon, 20 Feb 2017 12:38:10 GMT

t1:

LOAD * INLINE [

APN

inet

static

cvpn

];

NoConcatenate

load *,

if(WildMatch(APN,'inet'),'resident' ,

if(WildMatch(APN,'static'),'corporate',

if(WildMatch(APN, 'cvpn'),'test'))) as APN1

Resident t1;

drop Table t1;

rahulpawarb — Mon, 20 Feb 2017 13:15:06 GMT

Hello Peter,

Open script editor and replace APN field with below given expression:

if(APN = 'inet', 'resident', if(APN = 'static', 'corporate', if(APN = 'cvpn', 'test', APN))) AS APN

Regards!

Rahul