Combine 2 or more field in 1

[Anonymous]

Hi there,

Please help me to add new field D, which contain result from A, B, C. (simple way)

See below picture

Thanks,

[Anonymous]

No, it didn't work.

[Anonymous]

I want to remove value from Field1, when ID= 25776371 and keep all other value Field1

  IF(ID=25776371 ,"Field1", '', "Field1") as "Field1",

Cheers,

[Anonymous]

I got the result.

I used 2 load:

1.  load

A & B & C as D1,*

2. Load IF(D1='This weekThis week', 'This week',D1) as D, * resident ;

If you know how to use double condition in script

IF(Field1=NUMBER), then remove value from Field2 (replace for '') and keep all other value in Field 2

Please let me know.

Thanks,