topic Re: Create new field based on existing fields in App Development

Create new field based on existing fields

Tue, 06 Jun 2017 09:38:17 GMT

Hi there,

I need to create a new field (Distributor) based on two existing fields ( Disti_Name , Disti_Corp_ID) with the condition shown in table below.

Is there any way to do this other than hard code?

thanks!

felipedl — Tue, 06 Jun 2017 12:54:38 GMT

Hi Alice,

You could do it in two ways:

1: create during the table load statement a concatenation of the two fields, something like

load * Inline

[

Disti_Name,Disti_Corp_ID,Distributor

A_B,A B,AB

A_C,A C,AC

A_D,A D,AD

];

NoConcatenate

Data:

Load

Disti_Name,

Disti_Corp_ID,

Distributor,

Disti_Name & '|' & Disti_Corp_ID as Key_LoadStatement

Resident x;

drop table x;

Or create a table with the expression:

"=Disti_Name & Disti_Corp_ID"

Attached is a QVW with both options.

Regards,

Felipe. !

Wed, 07 Jun 2017 10:02:16 GMT

Thanks Felip. Will test on this and update here.