Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to create/use a calculated field on the load where you reference itself?
Exercises:
Load * Inline [
ID, Exercise, Date, Result
x, x, x, x
x, x, x, x
];
NewTable:
load *,
if(previous(Status) = 'Tier1', 'Tier2', 'Tier1') as Status
Resident Exercises;
Hi,
Try this.
if(Peek(Status) = 'Tier1', 'Tier2', 'Tier1') as Status
Regards,
Kaushik Solanki
Hi,
Try this.
if(Peek(Status) = 'Tier1', 'Tier2', 'Tier1') as Status
Regards,
Kaushik Solanki
That did it! Peek instead of Previous... now I know. Thanks!!!!