Appendix D: What's new in 4.x

New functions in 4.x

1. RunSQL

2. Encrypt

3. Decrypt

4. InmemoryLookup

5. SplitTextInColumns

6. AppendTableOnNames

7. AppendTable

8. Lookup (Syntax changed)

9. AddLookupColumn (Syntax changed)

10. GroupBy (Syntax changed)

11. Sort (Syntax changed)

Obsolete Functions

1. BetweenRanges

2. Search

3. ColumnProfile

4. FindRelations

5. LevenshteinDistance

6. DistinctRows

7. Group

8. UnmatchedRows

9. GetTable

10. GroupLegacy

11. UnmatchedColumns

12. UnmatchedRecords

13. ClosestBoolean

14. ClosestNumber

15. SortByHitRate

16. Union

17. UnionOnNames

Replacement for Obsolete Functions

1. BetweenRanges --> Between
2. Search --> CharIndex
3. Group --> GroupBy
4. UnmatchedRows --> FindNewRecords
5. UnMatchedColumns --> FindNewRecords
6. UnionOnNames --> AppendTableOnNames
7. Union --> AppendTable