{"formatVersion":1,"graph":{"connections":[[["5f41cfbc-2a45-4e25-8281-e78a5e43c17c",2],["43003881-9592-4c0d-a015-82232f110287",1]],[["8e489335-e013-42b3-b313-ed1820f225e1",1],["5f41cfbc-2a45-4e25-8281-e78a5e43c17c",3]],[["43003881-9592-4c0d-a015-82232f110287",2],["c901176d-a1f8-4b39-8087-afc7d9ba9d5b",1]]],"nodes":[{"$type":"importExcel","sheetNumber":1,"range":null,"hasHeaders":true,"skipErroneousRows":false,"id":"5f41cfbc-2a45-4e25-8281-e78a5e43c17c","name":"Поставки","description":null,"ports":[{"$type":"streamInputPort","id":1,"tag":null,"direction":"in","parameterId":"fe9369d3-a0fe-4fd7-b989-d9b39e3dec8f"},{"$type":"tableOutputPort","id":2,"tag":"main","direction":"out"},{"$type":"priorityControlInputPort","id":3,"tag":null,"direction":"in","parameterId":null}]},{"$type":"projectionNode","rules":[{"$type":"addCalculatedColumn","formula":"Сейчас()","columnName":"Дата и время загрузки данных"}],"removeInputColumns":false,"sortRules":[],"id":"43003881-9592-4c0d-a015-82232f110287","name":"Проекция","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":null,"direction":"out"}]},{"$type":"insertToWidgetTableNode","tableSchema":"Анализ продаж","table":"Поставки","createTableIfNotExists":true,"id":"c901176d-a1f8-4b39-8087-afc7d9ba9d5b","name":"Аналитическая таблица \"Поставки\"","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":null,"direction":"out"}]},{"$type":"sqlQueryNode","query":"truncate \"Анализ продаж\".\"Поставки\"","language":"Sql","id":"8e489335-e013-42b3-b313-ed1820f225e1","name":"Очистка аналитической таблицы","description":null,"ports":[{"$type":"priorityControlOutputPort","id":1,"tag":null,"direction":"out"}]}]},"layout":{"paperSize":{},"nodes":{"5f41cfbc-2a45-4e25-8281-e78a5e43c17c":{"position":{"x":160,"y":180},"size":{"width":150,"height":40}},"43003881-9592-4c0d-a015-82232f110287":{"position":{"x":160,"y":260},"size":{"width":150,"height":40}},"c901176d-a1f8-4b39-8087-afc7d9ba9d5b":{"position":{"x":130,"y":350},"size":{"width":210,"height":40}},"8e489335-e013-42b3-b313-ed1820f225e1":{"position":{"x":340,"y":80},"size":{"width":200,"height":40}}},"links":{}},"params":[{"id":"fe9369d3-a0fe-4fd7-b989-d9b39e3dec8f","caption":"Входящий Excel","value":"Пусто","text":"","visual":true,"multiple":false,"datatype":"file"}]}