Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Current »

Scenario

Combine data from 2 sources into 1 set of data. For each record in each data set, you get one record.

Example

You have a set of customers stored in one system. You have a set of customers in another system. There are no overlaps. You want all your customers in one list.

The below screenshots shows how you can combine 2 data sets to create a single data set containing all records from both. (i.e. the equivalent of a union in SQL). To do this have the 2 calculate tables pipe into a single merge table. The same principal applies if you are also combining more than 2 tables.

If you refer to an attribute without a pipe name prefix, i.e. Attribute1, rather than in1.Attribute1, then PhixFlow expects that attribute to exist in all source pipes.

If you do not put an attribute expression, then PhixFlow expects to find an attribute with exactly the same name as itself in all source pipes.

If your attribute is called something different in each source table, then you will need to check the pipe name to work out which attribute to use. This is shown in Attribute3 in the screenshot. _pipeName is an internal variable that stores the pipe name of the current record.


  • No labels