Dynamic Formula - Introduction

DF is a very powerful feature of Process Runner with which you can assign specific validations to selective Mappings types. Assigned mapped values can be dynamically changed at runtime with the help of DF.

Process Runner supports 19 widely used predefined DFs on Field & 1 Custom Formula if the user wants to write his own transformation function. Process Runner supports DF to be written in VB.NET.

1.Custom Formula

2.Add Leading Zeros

3.Decimal Transform . to ,

4.Decimal Transform , to .

5.Transform Excel Date to DD.MM.YYYY

6.Transform Excel Date to MM/DD/YYYY

7.Transform Excel Date to MM-DD-YYYY

8.Transform Excel Date to YYYY.MM.DD

9.Transform Excel Date to YYYY/MM/DD

10.Transform Excel Date to YYYY-MM-DD

11.Transform YYYYMMDD date to DD.MM.YYYY

12.Transform YYYYMMDD date to MM/DD/YYYY

13.Transform YYYYMMDD date to MM-DD-YYYY

14.Transform YYYYMMDD date to YYYY.MM.DD

15.Transform YYYYMMDD date to YYYY/MM/DD

16.Transform YYYYMMDD date to YYYY-MM-DD

17.Convert To absolute value (remove negative sign)

18.Transform to debit/credit indicator (H/S)

19.Remove Spaces / Accounting Formats

20.Get Internal Value

21.R-Split & Append Long Text Line(s)

Besides this, Process Runner also supports DRS (Dynamic Row Splitter) on Loops.

In here we will be looking at the following topics to get an idea how Dynamic Formula actually works.

1.   Add Leading Zeros

2.   Decimal Transform . to ,

3.   Transform Excel Date to DD.MM.YYYY

4.   Transform YYYYMMDD date to DD.MM.YYYY

5.   Custom Formula

6. Split & Append Long Text Line(s)