{"formatVersion":1,"graph":{"connections":[[["3d6c346c-143e-4572-949d-90865f837cfd",1],["73cd75a1-dafa-4a03-adf9-744197861d20",1]],[["73cd75a1-dafa-4a03-adf9-744197861d20",3],["5f63136d-8566-4fed-82f1-4845e49e010e",1]],[["73cd75a1-dafa-4a03-adf9-744197861d20",2],["4e2653d8-8f10-4f32-b170-094248928290",1]],[["5f63136d-8566-4fed-82f1-4845e49e010e",2],["4e2653d8-8f10-4f32-b170-094248928290",3]],[["4e2653d8-8f10-4f32-b170-094248928290",2],["774d926d-89e8-4ec7-a3a9-b43e84e8ea70",1]],[["774d926d-89e8-4ec7-a3a9-b43e84e8ea70",2],["8aaa4685-5c8a-40bc-b0ed-f5955ad15572",1]],[["8aaa4685-5c8a-40bc-b0ed-f5955ad15572",2],["2f5692b0-73d1-459e-96e5-865c49773295",1]],[["2f5692b0-73d1-459e-96e5-865c49773295",2],["77ae2c9b-e222-4935-9238-7d149e170043",1]]],"nodes":[{"$type":"loadFileNode","filePath":"\\\\tarasova_en\\Shared\\etl_test\\Товары.xlsx","id":"3d6c346c-143e-4572-949d-90865f837cfd","name":"Файл Товары.xlsx","description":null,"ports":[{"$type":"streamOutputPort","id":1,"tag":null,"direction":"out"}]},{"$type":"importExcel","sheetNumber":1,"range":null,"hasHeaders":true,"skipErroneousRows":true,"id":"73cd75a1-dafa-4a03-adf9-744197861d20","name":"Товары","description":null,"ports":[{"$type":"streamInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":"main","direction":"out"},{"$type":"tableOutputPort","id":3,"tag":"errors","direction":"out"}]},{"$type":"projectionNode","rules":[{"$type":"addCalculatedColumn","formula":"ВДробное(Заменить([Цена, ₽/кг]; \" рублей\"; \"\"))","columnName":"Цена, ₽/кг"}],"removeInputColumns":false,"sortRules":[],"id":"5f63136d-8566-4fed-82f1-4845e49e010e","name":"Обработка ошибок","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":null,"direction":"out"}]},{"$type":"unionNode","distinct":false,"id":"4e2653d8-8f10-4f32-b170-094248928290","name":"Объединение 1","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":"main","direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":null,"direction":"out"},{"$type":"tableInputPort","id":3,"tag":null,"direction":"in","parameterId":null},{"$type":"tableInputPort","id":6,"tag":null,"direction":"in","parameterId":null}]},{"$type":"expandRowsNode","column":"Примечание","mode":"Delimiter","delimiter":", ","id":"774d926d-89e8-4ec7-a3a9-b43e84e8ea70","name":"Развернуть примечание  в строки","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":null,"direction":"out"}]},{"$type":"distinctNode","keyColumns":["Товар","Цена, ₽/кг","Примечание"],"sortRules":[],"id":"8aaa4685-5c8a-40bc-b0ed-f5955ad15572","name":"Удалить дубликаты","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":null,"direction":"out"}]},{"$type":"filterNode","condition":"[Цена, ₽/кг] != Пусто","id":"2f5692b0-73d1-459e-96e5-865c49773295","name":"Товары с ценой","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":null,"direction":"out"}]},{"$type":"entityInsertNode","columns":[{"sourceColumn":"Товар","targetColumn":"name"},{"sourceColumn":"Цена, ₽/кг","targetColumn":"price"},{"sourceColumn":"Примечание","targetColumn":"description"}],"model":"online_shop","entity":"product","id":"77ae2c9b-e222-4935-9238-7d149e170043","name":"Вставка строк Колибри","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":"inserted","direction":"out"}]}]},"layout":{"paperSize":{},"nodes":{"3d6c346c-143e-4572-949d-90865f837cfd":{"position":{"x":240,"y":30},"size":{"width":150,"height":40}},"73cd75a1-dafa-4a03-adf9-744197861d20":{"position":{"x":240,"y":110},"size":{"width":150,"height":40}},"5f63136d-8566-4fed-82f1-4845e49e010e":{"position":{"x":340,"y":190},"size":{"width":150,"height":40}},"4e2653d8-8f10-4f32-b170-094248928290":{"position":{"x":260,"y":260},"size":{"width":150,"height":40}},"774d926d-89e8-4ec7-a3a9-b43e84e8ea70":{"position":{"x":230,"y":340},"size":{"width":210,"height":40}},"8aaa4685-5c8a-40bc-b0ed-f5955ad15572":{"position":{"x":260,"y":420},"size":{"width":150,"height":40}},"2f5692b0-73d1-459e-96e5-865c49773295":{"position":{"x":260,"y":500},"size":{"width":150,"height":40}},"77ae2c9b-e222-4935-9238-7d149e170043":{"position":{"x":260,"y":580},"size":{"width":150,"height":40}}},"links":{}}}