{"formatVersion":1,"graph":{"connections":[[["801039c6-24bd-4d31-9e1b-c52628833194",1],["010ffe80-9630-4526-8fc4-410426c6b4f2",1]],[["010ffe80-9630-4526-8fc4-410426c6b4f2",2],["fd972982-e7fa-4d1c-90d2-20d29ccac4c4",1]],[["010ffe80-9630-4526-8fc4-410426c6b4f2",2],["e8a31920-6a5e-4476-8b79-0e9ab5e19907",1]],[["fd972982-e7fa-4d1c-90d2-20d29ccac4c4",2],["5a2d408b-a320-4d15-b586-b1aff69e7645",2]],[["e8a31920-6a5e-4476-8b79-0e9ab5e19907",2],["5a2d408b-a320-4d15-b586-b1aff69e7645",3]]],"nodes":[{"$type":"loadFileNode","filePath":"c:\\users\\ivanov_ii\\shared\\etl_files\\bookstore.xml","id":"801039c6-24bd-4d31-9e1b-c52628833194","name":"Файл bookstore.xml","description":null,"ports":[{"$type":"streamOutputPort","id":1,"tag":null,"direction":"out"}]},{"$type":"loadXmlNode","addIdProperty":true,"idPropertyName":"id","id":"010ffe80-9630-4526-8fc4-410426c6b4f2","name":"Преобразовать из XML","description":null,"ports":[{"$type":"streamInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"xmlStreamOutputPort","id":2,"tag":null,"direction":"out"}]},{"$type":"xPathTableNode","rootElement":"//book","addParentId":false,"parentIdPropertyName":"","columns":[{"$type":"xPathTableColumn","columnName":"Наименование","xPath":"/book/@title"},{"$type":"xPathTableColumn","columnName":"Год","xPath":"/book/year"},{"$type":"xPathTableColumn","columnName":"Цена","xPath":"/book/price"},{"$type":"xPathTableColumn","columnName":"Автор_первый","xPath":"/book/author"}],"id":"fd972982-e7fa-4d1c-90d2-20d29ccac4c4","name":"Информация о книгах","description":null,"ports":[{"$type":"xmlStreamInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":null,"direction":"out"}]},{"$type":"xPathTableNode","rootElement":"//book/author","addParentId":true,"parentIdPropertyName":"book_id","columns":[{"$type":"xPathTableColumn","columnName":"Имя","xPath":"/author"}],"id":"e8a31920-6a5e-4476-8b79-0e9ab5e19907","name":"Информация об авторах","description":null,"ports":[{"$type":"xmlStreamInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":null,"direction":"out"}]},{"$type":"joinNode","rules":[{"portId":3,"join":"left","alias":"Автор","addColumnPrefix":true,"condition":"id = Автор.book_id"}],"projectionRules":[],"mainPortId":2,"removeInputColumns":false,"id":"5a2d408b-a320-4d15-b586-b1aff69e7645","name":"Присоединение к книгам авторов","description":null,"ports":[{"$type":"tableOutputPort","id":1,"tag":null,"direction":"out"},{"$type":"tableInputPort","id":2,"tag":null,"direction":"in","parameterId":null},{"$type":"tableInputPort","id":3,"tag":null,"direction":"in","parameterId":null}]}]},"layout":{"paperSize":{},"nodes":{"801039c6-24bd-4d31-9e1b-c52628833194":{"position":{"x":50,"y":30},"size":{"width":150,"height":40}},"010ffe80-9630-4526-8fc4-410426c6b4f2":{"position":{"x":50,"y":120},"size":{"width":150,"height":40}},"fd972982-e7fa-4d1c-90d2-20d29ccac4c4":{"position":{"x":50,"y":200},"size":{"width":150,"height":40}},"e8a31920-6a5e-4476-8b79-0e9ab5e19907":{"position":{"x":210,"y":200},"size":{"width":150,"height":40}},"5a2d408b-a320-4d15-b586-b1aff69e7645":{"position":{"x":100,"y":300},"size":{"width":190,"height":40}}},"links":{}}}