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.
