Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Need below Output field need to do in Script please help on this if Name = jone after row will return same name until ID<>Previous(ID)
ID | Name | OUT PUT |
111 | lee | |
111 | assds | |
111 | jone | jone |
111 | ssds | jone |
111 | sdd | jone |
111 | sdsas | jone |
111 | sasww | jone |
222 | eeee | |
222 | sdsd | |
222 | jone | jone |
222 | ddsd | jone |
222 | sddd | jone |
Try:
Load *, If(ID =Peek(ID), if( Name='jone', 'jone', Peek(Output))) as Output
Try:
Load *, If(ID =Peek(ID), if( Name='jone', 'jone', Peek(Output))) as Output