Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
Please help me to add new field D, which contain result from A, B, C. (simple way)
See below picture
Thanks,
No, it didn't work.
I want to remove value from Field1, when ID= 25776371 and keep all other value Field1
IF(ID=25776371 ,"Field1", '', "Field1") as "Field1",
Cheers,
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,