how can we merge values of a field in script level?

[#1]

Hi,

How can we merge values of a field in script. For ex;

Disease

A

B

C

D

and here i want 2 values c & d to get merged into 1 value nd named as others?

Please help.

[Anonymous]

if ( match( [Disease] , 'C' , ''D' ) , 'nd' ) as [others] ,

[jonathandienst]

Hi

LOAD A,

     B,

     C & D As others

....

HTH

Jonathan

[Anonymous]

Link the tables using Join statement and use Concat() function to merge th Values to C & D

[#5]

I tried

LOAD [Therapeutic Area] as %TA,

     Disease ,

     Histology,

FROM

(ooxml, embedded labels, table is Sheet1) Where if(match(Disease,'AML','CLL')) as Others;

and it is showing an error.

Please help

[#6]

These are not fields but the values of a field that i want to put together

[#7]

How do you mean "merge"?

[#8]

It is like

Disease

A

B

C

D

and in script while loading:

load

Area,

Disease,

Project

from xyz.xlsx

and now i want to merge the values in disease.

[aveeeeeee7en]

Hi Aakansha

Go to your script and write this code:

Load Disease,

if(WildMatch(Disease,'C','D'),Disease) AS Others,

if(WildMatch(Disease,'C','D'),'Others',Disease) AS Others11

From

your file path

[#10]

Try this:

Temp:

LOAD Area,

          Disease,

          Project

FROM xyz.xlsx

Real:

LOAD *,

          C & D as X

Resident Temp;

Drop Table Temp;