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.

[sundarakumar]

I think this will help

load

area,

project,

if(disease='a' or disease='b', disease,null())as disease,

if(disease='c' or disease='d',disease , null())as others

from

xyz.xlsx;

-Sundar

[#3]

C & D are the values not the fields

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.

/message/475688?et=watches.email.thread

[aveeeeeee7en]

See the Attached

Regards

Aviral Nag

[#5]

Hm, I think that will almost work, maybe this:

Temp:

LOAD Area,

          Project,

          Disease

FROM xyz.xlsx;

Real:

LOAD *,

          if(Disease='A' or Disease = 'B','Disease') as Others

          if(Disease='C' or Disease = 'D','Disease') as Others

[#6]

In this, others is coming as a separate field and Disease as separate but i want others to be included as a value.

[aveeeeeee7en]

What exactly you want. Explain your requirement on Excel.

[Anonymous]

Hi Aakansha,

Please update sample file,so able to help

[aveeeeeee7en]

In the Attached I have provide you 2 Fields named as others & Others11:

Try this:

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

Regards

[#10]

This is the requirement.

[#11]

I have tried this. but this creates one extra field others.

and i want others to be a value of disease as mentioned in Ex.xlsx