Versions Compared

Old Version 1

changes.mady.by.user Anthony George

Saved on

compared with

New Version Current

changes.mady.by.user Fiona Sargeant

Saved on

Key

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

Insert excerpt
_Banners
_Banners
nameanalysis
nopaneltrue

  • 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.

    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:

    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

    PhixFlow can extract data from multiple sources, we recommend for the purposes of reconciliation that data be kept initially in its raw form with the exception of a PhixFlow UID being applied to records. The latter will allow you to handle duplicate entries. This raw data will form the baseline for the imported data, telling us how many records were provided and what data was provisioned.






    Extraction

    Processing typically consists of:

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