Versions Compared

Old Version 1

changes.mady.by.user Anthony George

Saved on

compared with

New Version 2

changes.mady.by.user Anthony George

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
_Banners
_Banners
nameanalysis
nopaneltrue

Scenario

In an Excel table, I can add a new column that contains a formula to calculate values using data on other columns. How do I do this in PhixFlow?

Concepts

In a PhixFlow analysis model, data is loaded into streams from external sources, such as files and databases. Usually we want to calculate additional values and use them in subsequent streams. Key concepts to be aware of:

  • In PhixFlow, you use an expression to run calculations on data in order to generate different data from it.
  • The expression is in an attribute, which is like a column header in Excel.
  •  When you run the analysis model, PhixFlow runs the calculation on every record, adding the data to each cell in the attribute's column. 
    • PhixFlow processes attributes in the order they are listed in the stream. If you want to use a value from an attribute, it must appear earlier in the attribute list in the stream.

    There are one or more datasources that need to be extracted, transformed and loaded into a new target system.

    Image Added

    Let's expand this simple model to include the areas where PhixFlow brings benefits 


    Image Added

    Solution

    Extraction







    Extraction

    Processing typically consists of:

    1. Consolidation
    2. Transformation
    3. Enhancement and Enrichment
    4. Filtering
    5. Review
    6. Investigation
    7. Reconciliation