-
Notifications
You must be signed in to change notification settings - Fork 0
/
etl_Transformation_bp_xls_write.xmi
19 lines (19 loc) · 5.74 KB
/
etl_Transformation_bp_xls_write.xmi
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
<?xml version="1.0" encoding="ASCII"?>
<etl:Transformation xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:etl="http://www.neoflex.ru/meta/etl" name="bp_xls_write" label="bp_xls_write" jsonView="{"cells":[{"type":"devs.transformation.ExpressionSource","size":{"width":80,"height":80},"inPorts":[],"outPorts":["out"],"ports":{"groups":{"in":{"position":{"name":"left"},"attrs":{".port-body":{"fill":"white","magnet":"passive","stroke":"#000","r":10},".port-label":{"text":"","visibility":"hidden","fill":"#000"},"circle":{"r":7,"stroke":"#4d4d4dde","stroke-width":1}},"label":{"position":{"name":"left","args":{"y":10}}}},"out":{"position":{"name":"right"},"label":{"position":{"name":"right","args":{"y":10}}},"attrs":{".port-body":{"fill":"#4d4d4dde","stroke":"#000","r":10,"magnet":true},".port-label":{"text":"","visibility":"hidden","fill":"#000"},"circle":{"r":7,"stroke":"#4d4d4dde","stroke-width":1}}}},"items":[{"id":"out","group":"out","attrs":{".port-label":{"text":"out"}}}]},"position":{"x":180,"y":180},"angle":0,"id":"bb1cb40d-c2d4-4d8e-9be1-d1a1edac14b6","z":1,"name":"Expression_0","attrs":{".label":{"text":"Expression_0"}}},{"type":"devs.transformation.CSVTarget","size":{"width":80,"height":80},"inPorts":["in"],"outPorts":[],"ports":{"groups":{"in":{"position":{"name":"left"},"attrs":{".port-body":{"fill":"white","magnet":"passive","stroke":"#000","r":10},".port-label":{"text":"","visibility":"hidden","fill":"#000"},"circle":{"r":7,"stroke":"#4d4d4dde","stroke-width":1}},"label":{"position":{"name":"left","args":{"y":10}}}},"out":{"position":{"name":"right"},"label":{"position":{"name":"right","args":{"y":10}}},"attrs":{".port-body":{"fill":"#4d4d4dde","stroke":"#000","r":10,"magnet":true},".port-label":{"text":"","visibility":"hidden","fill":"#000"},"circle":{"r":7,"stroke":"#4d4d4dde","stroke-width":1}}}},"items":[{"id":"in","group":"in","attrs":{".port-label":{"text":"in"}}}]},"position":{"x":450,"y":180},"angle":0,"id":"b15bf9fb-9798-4d7b-a12c-7bcf69e60d7c","z":2,"name":"xls_target","attrs":{".label":{"text":"xls_target"}}},{"type":"devs.transformation.Flow","id":"01b91bb0-9941-4304-b4fc-e371304c9111","source":{"id":"bb1cb40d-c2d4-4d8e-9be1-d1a1edac14b6","selector":"g:nth-child(3) > g:nth-child(3) > circle:nth-child(1)","port":"out"},"target":{"id":"b15bf9fb-9798-4d7b-a12c-7bcf69e60d7c","port":"in","selector":"g:nth-child(3) > g:nth-child(3) > circle:nth-child(1)"},"z":3,"attrs":{}}]}">
<targets xsi:type="etl:CSVTarget" name="xls_target" label="xls_target" csvFormat="EXCEL" path="/temp/blueprint/xls_test.xls" header="true" quote=""" escape="\">
<inputPort name="CSV_1in">
<fields name="id" dataTypeDomain="DECIMAL"/>
<fields name="name" dataTypeDomain="STRING"/>
</inputPort>
<inputFieldsMapping xsi:type="etl:TableTargetFeature" inputFieldName="id" targetColumnName="id"/>
<inputFieldsMapping xsi:type="etl:TableTargetFeature" inputFieldName="name" targetColumnName="name"/>
</targets>
<sources xsi:type="etl:ExpressionSource" name="Expression_0" label="Expression_0" expression="Array(
 Map("id" -> new java.math.BigDecimal(1), "name" -> "1"),
 Map("id" -> new java.math.BigDecimal(2), "name" -> "2") 
)">
<outputPort name="Expression_0out">
<fields name="id" dataTypeDomain="DECIMAL"/>
<fields name="name" dataTypeDomain="STRING"/>
</outputPort>
</sources>
<transitions name="01b91bb0-9941-4304-b4fc-e371304c9111" start="//@sources.0/@outputPort" finish="//@targets.0/@inputPort"/>
<auditInfo changeUser="admin" changeDateTime="2019-06-20T12:06:42.813+0300" createUser="admin" createDateTime="2019-05-21T18:31:55.816+0300"/>
</etl:Transformation>