ConcatBlock

Description

This block is used to merge several tables into a unique one.  

Implementation

• Drag and drop a concat block from the palette in a data strategy

Properties

• Artifacts: Artifacts created by this block
  
  • Tables: the resulting table.
• Target: the table on which the concat will be applied.
• Keys:
• Mode:
  
• Tags Distribution:
  
• StatusPolicy: determines the status of the aggregated record
  • Union: will merge all the status into one. example: if you have one record with the fault status, one record with the down status and one record with the alarm status, the resulting status will be down, fault, alarm.
  • Intersection: will only keep the values which are common to all the aggregated records. example: if you have one record with the fault, down status, one record with the down, alarm status and one record with the down status, the resulting status will be down

Advanced Properties

• ColumnName: SFormat  used to customize the name of the columns (except Timestamp and Status)
• InvalidStatus: Filter which allows to ignore records with matching statuses. Any record with at least one of the selected statuses will be ignored. If no statuses are selected, no records will be filtered.