Icon

DLP loop

ExportDate ouverteNode 188Node 485Node 516Node 517Node 524Node 525Node 526Node 530Node 531Node 533Node 536Node 537Node 538Node 543Node 544Node 545Node 546Node 547Node 548Node 549Node 550Node 551Node 552Node 553Node 554Node 555Node 558Node 559Node 560Node 561Node 564Node 567Node 568Node 569Node 572Node 573Node 574Node 575Node 576Node 577Node 578Node 579Node 580Node 581Node 582Node 583Node 584Node 585Node 586Node 587Node 588Node 589Node 590Node 591Node 592Node 593Node 594Node 595Node 596Node 597Node 600Trouve toutes les dates possiblesNode 604Node 605Node 608Node 609Node 610Node 611Node 612Node 613Node 614Node 615Node 616Node 617Node 618Node 619Node 620Node 621Node 622Node 623Node 624Node 625Node 626Node 627Node 628Node 629Node 630Node 631Node 632Définition variable sur 1ère date ouverteExclusion des dates ouvertes si NDLP >Node 636Node 639Node 640Node 641Node 644Node 645Node 646Node 647Node 648Node 649Node 650Node 651Node 652Node 653Node 654Node 655Node 656Node 657Node 658Node 659Node 660Node 661Node 662Node 663Node 664Node 665Node 666Node 667Node 668Node 669Node 670Node 675CXCXNode 678AMAMSDSDFXFXNode 685Node 686Node 687Node 688Début de boucleNode 690Node 691Node 693Node 694Node 695Node 696Excel Reader Excel Reader Column Filter Cross Joiner String to Date&Time Rule Engine Row Filter Joiner Row Filter GroupBy Joiner Column Resorter Math Formula Rule Engine Column Filter GroupBy Rule Engine Table Rowto Variable IF Switch Joiner Row Filter Row Filter End IF Row Filter Extract TableDimension Table Rowto Variable Rule Engine Row Filter Sorter Table Rowto Variable Date&Time-basedRow Filter revue date ouverte Column Filter Cross Joiner String to Date&Time Rule Engine Row Filter Joiner Row Filter GroupBy Joiner Column Resorter Math Formula Rule Engine Column Filter GroupBy Rule Engine Table Rowto Variable IF Switch Joiner Row Filter Row Filter End IF Row Filter Extract TableDimension Table Rowto Variable Rule Engine Row Filter Sorter Table Rowto Variable Date&Time-basedRow Filter revue date ouverte Column Filter Cross Joiner String to Date&Time Rule Engine Row Filter Joiner Row Filter GroupBy Joiner Column Resorter Math Formula Rule Engine Column Filter GroupBy Rule Engine Table Rowto Variable IF Switch Joiner Row Filter Row Filter End IF Row Filter Extract TableDimension Table Rowto Variable Rule Engine Row Filter Sorter Table Rowto Variable Date&Time-basedRow Filter revue date ouverte Column Filter Cross Joiner String to Date&Time Rule Engine Row Filter Joiner Row Filter GroupBy Joiner Column Resorter Math Formula Rule Engine Column Filter GroupBy Rule Engine Table Rowto Variable IF Switch Joiner Row Filter Row Filter End IF Row Filter Extract TableDimension Table Rowto Variable Rule Engine Row Filter Sorter Table Rowto Variable Date&Time-basedRow Filter revue date ouverte Concatenate Remove WHdate & capa Export filter alert& clean columns Date ouverte transposeet capa réelle RecursiveLoop Start Export filter alert& clean columns Date ouverte transposeet capa réelle Export filter alert& clean columns Date ouverte transposeet capa réelle Date ouverte transposeet capa réelle Export filter alert& clean columns RecursiveLoop Start Recursive Loop End Recursive Loop End RecursiveLoop Start RecursiveLoop Start Recursive Loop End Recursive Loop End Excel Writer Rule-basedRow Filter Joiner Pivoting ExportDate ouverteNode 188Node 485Node 516Node 517Node 524Node 525Node 526Node 530Node 531Node 533Node 536Node 537Node 538Node 543Node 544Node 545Node 546Node 547Node 548Node 549Node 550Node 551Node 552Node 553Node 554Node 555Node 558Node 559Node 560Node 561Node 564Node 567Node 568Node 569Node 572Node 573Node 574Node 575Node 576Node 577Node 578Node 579Node 580Node 581Node 582Node 583Node 584Node 585Node 586Node 587Node 588Node 589Node 590Node 591Node 592Node 593Node 594Node 595Node 596Node 597Node 600Trouve toutes les dates possiblesNode 604Node 605Node 608Node 609Node 610Node 611Node 612Node 613Node 614Node 615Node 616Node 617Node 618Node 619Node 620Node 621Node 622Node 623Node 624Node 625Node 626Node 627Node 628Node 629Node 630Node 631Node 632Définition variable sur 1ère date ouverteExclusion des dates ouvertes si NDLP >Node 636Node 639Node 640Node 641Node 644Node 645Node 646Node 647Node 648Node 649Node 650Node 651Node 652Node 653Node 654Node 655Node 656Node 657Node 658Node 659Node 660Node 661Node 662Node 663Node 664Node 665Node 666Node 667Node 668Node 669Node 670Node 675CXCXNode 678AMAMSDSDFXFXNode 685Node 686Node 687Node 688Début de boucleNode 690Node 691Node 693Node 694Node 695Node 696Excel Reader Excel Reader Column Filter Cross Joiner String to Date&Time Rule Engine Row Filter Joiner Row Filter GroupBy Joiner Column Resorter Math Formula Rule Engine Column Filter GroupBy Rule Engine Table Rowto Variable IF Switch Joiner Row Filter Row Filter End IF Row Filter Extract TableDimension Table Rowto Variable Rule Engine Row Filter Sorter Table Rowto Variable Date&Time-basedRow Filter revue date ouverte Column Filter Cross Joiner String to Date&Time Rule Engine Row Filter Joiner Row Filter GroupBy Joiner Column Resorter Math Formula Rule Engine Column Filter GroupBy Rule Engine Table Rowto Variable IF Switch Joiner Row Filter Row Filter End IF Row Filter Extract TableDimension Table Rowto Variable Rule Engine Row Filter Sorter Table Rowto Variable Date&Time-basedRow Filter revue date ouverte Column Filter Cross Joiner String to Date&Time Rule Engine Row Filter Joiner Row Filter GroupBy Joiner Column Resorter Math Formula Rule Engine Column Filter GroupBy Rule Engine Table Rowto Variable IF Switch Joiner Row Filter Row Filter End IF Row Filter Extract TableDimension Table Rowto Variable Rule Engine Row Filter Sorter Table Rowto Variable Date&Time-basedRow Filter revue date ouverte Column Filter Cross Joiner String to Date&Time Rule Engine Row Filter Joiner Row Filter GroupBy Joiner Column Resorter Math Formula Rule Engine Column Filter GroupBy Rule Engine Table Rowto Variable IF Switch Joiner Row Filter Row Filter End IF Row Filter Extract TableDimension Table Rowto Variable Rule Engine Row Filter Sorter Table Rowto Variable Date&Time-basedRow Filter revue date ouverte Concatenate Remove WHdate & capa Export filter alert& clean columns Date ouverte transposeet capa réelle RecursiveLoop Start Export filter alert& clean columns Date ouverte transposeet capa réelle Export filter alert& clean columns Date ouverte transposeet capa réelle Date ouverte transposeet capa réelle Export filter alert& clean columns RecursiveLoop Start Recursive Loop End Recursive Loop End RecursiveLoop Start RecursiveLoop Start Recursive Loop End Recursive Loop End Excel Writer Rule-basedRow Filter Joiner Pivoting

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: negrobar.d
Created at: 2022-10-17
On NodePit since: 2022-11-22
Last update: 2024-04-27
Created with KNIME version: v4.6.3

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!