Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
attached is a sample data file (is a personal/desktop) edition.
The output i want to obtain is the following:
if field5 = 0, the first 5 number of field4 and the last two of the same field.
applymap and left() / right () functions can coexist?
Thanks,
Mattia
May be this
If([FIELD5] = 0, Left(ApplyMap('KEY_TO_FIELD4', [FIELD2], 'n/a'), 7) & ',' & Right(ApplyMap('KEY_TO_FIELD4', [FIELD2], 'n/a'), 2)) as New_Field
May be this
If([FIELD5] = 0, Left(ApplyMap('KEY_TO_FIELD4', [FIELD2], 'n/a'), 7) & ',' & Right(ApplyMap('KEY_TO_FIELD4', [FIELD2], 'n/a'), 2)) as New_Field