Create a new field from the Existing fields...

[Kohli]

I have below table.

Flight                               stop type        Origin        Stop place         Destinatiom

703	1	MXP	FCO	ADD
737	1	IAH	DEN	SFO
507	1	BKK	KHI	MCT
1578	1	LAX	IAH	BOS

555/558	CNX	KTM	SIF	KTM
557/560	CNX	KTM	SIF	KTM
207/614	CNX	DAR	ZNZ	DAR
103/118	CNX	DAR	ZNZ	DAR
117/106	CNX	DAR	ZNZ	DAR

I want create a new field Flight Destination from the Existing fields. If Stop Point=1, I want Flight Destination= Destination Field records,

or  stoptype= CNX, i want Flight destination= Stop place filed records. I want output records like...

Flight Destination  (NEW COLUMN)

ADD

SFO

MCT

BOS

SIF

SIF

ZNZ

ZNZ

ZNZ

[jonathandienst]

Do you want to do this in the load script or in the front end?

[Kohli]

In Script

[Anonymous]

Hi,

try Below If Condition.

if( [stop type]=1,Destination,if([stop type]='CNX', [Stop place]) ) as  NewField;

find the attached App

[Anonymous]

Hi,

PFA attached Sample

Regards

Ritesh

[sewialwork]

Try this in your script

If([ stop type]=1,[Destinatiom],[Stop place]) as [Flight Destination]

AGB