Icon

Mediolanum_​saldoMedio_​v9_​2025Q3_​v7_​Paq1

CONTRATOS TOTALESCON INBEST CONTRATOS TOTALESCON INBEST PENDIENTE CONFIRMAR TOTAL CONTRATOS FONDOS POSICION DIARIA FONDOS DESTINOINBEST SEPARAMOSENTRE STEPS INY STEPS OUT SEPARAMOSENTRE STEPS INY STEPS OUT SEPARAMOS ENTREOPERACIONES DURANTEEL PERIODO Y ANTES DELPERIODO PENDIENTE CONFIRMAR DESCARTAMOS POSIBLESOPERACIONES POSTERIORES AFIN DE PERIODO O ANTERIORESAL INICIO DEL SERVICIO CONTROLAMOS LOS CASOS EN LOS QUE NO HAYA HABIDOMOVIMIENTOS DESCARTAMOS STEPS OUT ENCONTRATOS VIEJOS (DISTINTOS A 50.0) ELIMINAMOS LOS SI Y SO ENLASFECHAS EN LAS QUE NO HAY IMPORTENOMINAL (SERVICIO NO ACTIVO) SEPARAMOS DEVO Y FONDE PARABUSCAR LAS POSICIONES SALDO MEDIO 0 PARA TODO LOQUE NO SE HA LOCALIZADOEN LAS TBLAS DE POSIONES.DESCARTADAS SERVICIOS SIN SI ni SO, HAYQUE TENER EN CUENTA ELNOMINAL COMPROMETIDO. NOS QUEDAMOS SOLO CON LOSCONTRATOS DEVO, FOND y CAMG BUSCAMOS LOS SERVICIOS(CONTRATO GEIN + ORDEN)ASOCIADOS A LOS FONDOSLOCALIZADO QUITAR QUITAR QUITAR FGEINCONFINVEXIFGEINCABNode 4Node 5FCONPRLNode 7Node 8Node 9Node 10HeaderNode 12Node 13FBOXSERCNode 15Node 16Node 17Node 18FBOXORDCNode 20HeaderConInbestNode 23FBOXORDDNode 26Node 28Node 29Node 30FTRFORDNode 32Node 33Node 34Node 36FINVMOVNode 38Node 39Node 40Node 53HeaderNode 55ConfigNode 65Node 66Node 67Node 68Node 69Node 70SeparamosAgrupamos por servicio y fondoNode 74Agrupamos por serv. y fondoNode 77Node 81Node 82Node 83Node 84Node 85Node 86Node 87Node 88Node 89Node 91Node 92Node 93Node 94Node 95Node 96Node 97Node 102Node 103Node 104Node 105Node 106Node 107Node 108Node 109Node 110Node 111Node 112Node 113Node 114Node 115Node 116Node 117Node 122Node 123Node 124Node 125Node 126Node 127Node 128Node 129Node 130Node 131Node 132Nominal x fondoNode 134Node 135Node 136Node 137Node 138Node 139Node 140Node 142Node 143Node 144Node 145Node 148Node 150Node 167Node 174Node 176Node 177Node 179Node 180Node 181Node 182Node 183Node 184Node 185Node 186Node 187Node 188Node 192Node 193Node 194Node 195Node 196Node 197Node 198Node 199Node 200Node 201Node 202Node 203Node 204Node 205Node 206Node 207Node 208Node 209Node 212Node 213Node 214CRUCE FINEXINode 217Sin InbestNode 223Node 224Node 225Node 249Cambiamos signoQuitamos CNUMORD 0FFONEXISeparamos DEVO y FONDECruce FONEXINode 264Node 265Node 267Node 268Node 271Node 272Node 274Node 283Node 284Node 285Node 287Node 291Node 292Node 293Node 294Node 295Node 296Node 297Node 298Node 299Node 300Node 301Node 302Node 303Node 304Node 305Node 306Node 316Node 318Node 319Node 320Node 321Node 323Node 324Node 325Node 326Node 327Quitamos los CREFORD = 0CRFORD igual a 0Node 332Node 333Node 339Node 340Node 341Node 342Node 343Node 344Node 347Node 349Node 350DESCARTAMOS SERVICIOSNode 358Node 363Node 365Node 366Node 367Node 368Node 369Node 376Node 1084DEVONode 1086Node 1087Node 1088Node 1089Node 1090Node 1092Node 1096Node 1097Node 1098Node 1099Node 1100FINVCARNode 1102Node 1103FONDE-CAMGNode 1105Node 1106Node 1107Node 1108Node 1109Node 1111PARALELO_SMNode 1113Node 1114Node 1115Node 1116Node 1117SeparamosTESTNode 1120Node 1122Node 1123Node 1124Node 1125Node 1126Node 1127CTIVO EN PERIODONode 1130Node 1131Node 1132Node 1134Node 1135Node 1136Node 1138Node 1141Node 1142Node 1143Node 1144Node 1145Node 1146COMPARA1COMPARA2COMPARA3Node 1150Node 1151DESCARTAMOS Node 1164Node 1166Node 1167Node 1168Node 1169Node 1170Servicios sin movimientosNode 1173DESCARTAMOS SERVICIOSNode 132Node 1176Node 1179Node 1180Node 1181Node 1182Node 1183Node 1184Node 1189FMOVFONDE_V2Cogemos F. OperNode 1200SeparamosNode 1210Node 1211Node 1214FCONCAMGNode 1216Node 1225FALLECIDOSNode 1243SALDO DIARIO NEG A CERONode 1249Node 1250Node 1251Node 1252Node 1253Node 1255Node 1256Node 1257Node 1258Node 1259Node 1260Node 1261Node 1262Node 1263Node 1264Node 1265Node 1266Node 1267Node 1268Node 1269Node 1270Node 1271Node 1272Node 1273Node 1274Node 1275Node 1305Node 1307Node 1308Node 1309Node 1310Node 1311Node 132Node 1313Node 1314Node 1315Node 1316Node 1317Node 1318Node 1320Node 1329Node 1335Node 1336Node 1337Node 1338Node 1339Node 1340Node 1341SALIDANode 1343FOTPSERNode 1366Node 1368Node 1369Node 1370Node 1371COMPARA4 CSV Reader CSV Reader CSV Reader Column Filter Column Renamer CSV Reader Column Filter Column Renamer Rule-basedRow Filter Column Renamer(Dictionary) Excel Reader Joiner Joiner CSV Reader Sorter Column Renamer Joiner Rule-basedRow Filter CSV Reader Column Renamer(Dictionary) Excel Reader Joiner Sorter CSV Reader Column Filter Joiner Column Renamer Column Filter CSV Reader Column Renamer Column Filter Joiner Sorter CSV Reader Column Renamer Joiner Rule-basedRow Splitter Column Renamer(Dictionary) Excel Reader Joiner Excel Reader Table Rowto Variable Sorter String to Number GroupBy Sorter Create Date&TimeRange Rule-basedRow Splitter GroupBy Sorter GroupBy Sorter Rule-basedRow Splitter Column Renamer Column Renamer Joiner Column Filter Column Filter Column Filter Concatenate Missing Value GroupBy Table Row toVariable Loop Start Rule-basedRow Filter Joiner Loop End Rule Engine Rule Engine Missing Value Moving Aggregator Extract TableDimension Table Rowto Variable Rule-basedRow Splitter Column Renamer Column Renamer Joiner Column Filter Column Filter Column Filter Concatenate Missing Value Rule-basedRow Filter Concatenate Rule Engine String to Date&Time GroupBy Joiner Rule Engine Rule Engine Concatenate Concatenate DuplicateRow Filter Column Filter Column Filter Rule Engine GroupBy GroupBy Joiner String Manipulation String Manipulation String to Number Number to String Joiner Column Renamer String to Number Math Formula Number to String String to Date&Time Rule-basedRow Filter Joiner Sorter Rule Engine String to Date&Time Rule Engine GroupBy Table Row toVariable Loop Start Rule-basedRow Filter GroupBy GroupBy Column Renamer Column Renamer Concatenate Joiner Rule-basedRow Filter Date&Time tolegacy Date&Time Time Difference(legacy) Table Rowto Variable Moving Aggregator Double to Integer Rule Engine Rule Engine Rule Engine Rule Engine Rule Engine Rule Engine Rule Engine Loop End DuplicateRow Filter Rule Engine Rule Engine Rule Engine Legacy Date&Timeto Date&Time Sorter Rule-basedRow Filter GroupBy Joiner GroupBy String Manipulation String Manipulation String to Number Number to String Concatenate String Manipulation Row Filter CSV Reader Row Splitter Joiner GroupBy Column Renamer String to Date&Time Number to String Concatenate Column Filter Column Expressions Time Difference(legacy) Date&Time tolegacy Date&Time Legacy Date&Timeto Date&Time Math Formula Rule-basedRow Filter Rule-basedRow Filter GroupBy Row Splitter Table Row toVariable Loop Start Rule-basedRow Filter Joiner Sorter Missing Value Loop End GroupBy String to Number Math Formula Math Formula String to Number Math Formula(Multi Column) GroupBy Joiner Column Filter Column Filter ConstantValue Column ConstantValue Column Column Renamer Column Renamer Concatenate SaldoMedio Row Filter Rule-basedRow Splitter Joiner Concatenate Joiner Column Filter Column Renamer Concatenate Missing Value Missing Value Row Filter Rule-basedRow Splitter GroupBy Rule-basedRow Splitter Rule Engine Format_Date Joiner String to Number Math Formula Number to String String to Date&Time Column Expressions GroupBy Joiner Column Expressions String Manipulation Rule-basedRow Splitter Concatenate Concatenate Missing Value Joiner GroupBy Column Filter ConstantValue Column GroupBy CSV Reader Joiner Column Renamer Joiner Column Expressions String Manipulation Concatenate ConstantValue Column Concatenate Concatenate CSV Reader Column Renamer Rule-basedRow Splitter Joiner Joiner Missing Value Rule-basedRow Splitter Rule-basedRow Filter String to Number Number to String String to Date&Time Math Formula(Multi Column) Rule Engine Rule Engine Rule Engine Rule-basedRow Splitter Rule Engine String to Date&Time Time Difference(legacy) Math Formula Legacy Date&Timeto Date&Time Date&Time tolegacy Date&Time Joiner Column Filter Concatenate Rule Engine Missing Value Math Formula Math Formula Excel Writer Excel Writer Excel Writer Sorter Sorter Rule-basedRow Splitter Math Formula(Multi Column) GroupBy Rule Engine Rule Engine Rule Engine GroupBy Joiner Format_Date Rule-basedRow Splitter GroupBy Concatenate String to Number Sorter Joiner Math Formula(Multi Column) Math Formula Math Formula DuplicateRow Filter CSV Reader Column Renamer Rule Engine Rule-basedRow Splitter DesagregaClacon Joiner Row Filter CSV Reader Column Renamer Rule-basedRow Splitter Excel Reader Joiner Rule Engine Rule-basedRow Filter GroupBy Joiner Rule-basedRow Filter Column Renamer Rule-basedRow Filter Rule-basedRow Filter GroupBy GroupBy Joiner GroupBy Joiner Rule Engine Rule Engine Rule Engine Column Filter Concatenate Rule Engine Rule Engine Column Filter Column Renamer Column Resorter Concatenate Concatenate Column Renamer Excel Writer Column Filter GroupBy GroupBy Joiner Joiner Format_Date GroupBy Concatenate DuplicateRow Filter String to Number GroupBy GroupBy Joiner Joiner Concatenate Rule-basedRow Splitter Math Formula(Multi Column) Joiner Rule Engine Rule-basedRow Splitter Rule Engine Concatenate Excel Writer Column Filter CSV Reader Rule Engine Rule-basedRow Splitter Rule Engine Rule Engine String to Number Excel Writer CONTRATOS TOTALESCON INBEST CONTRATOS TOTALESCON INBEST PENDIENTE CONFIRMAR TOTAL CONTRATOS FONDOS POSICION DIARIA FONDOS DESTINOINBEST SEPARAMOSENTRE STEPS INY STEPS OUT SEPARAMOSENTRE STEPS INY STEPS OUT SEPARAMOS ENTREOPERACIONES DURANTEEL PERIODO Y ANTES DELPERIODO PENDIENTE CONFIRMAR DESCARTAMOS POSIBLESOPERACIONES POSTERIORES AFIN DE PERIODO O ANTERIORESAL INICIO DEL SERVICIO CONTROLAMOS LOS CASOS EN LOS QUE NO HAYA HABIDOMOVIMIENTOS DESCARTAMOS STEPS OUT ENCONTRATOS VIEJOS (DISTINTOS A 50.0) ELIMINAMOS LOS SI Y SO ENLASFECHAS EN LAS QUE NO HAY IMPORTENOMINAL (SERVICIO NO ACTIVO) SEPARAMOS DEVO Y FONDE PARABUSCAR LAS POSICIONES SALDO MEDIO 0 PARA TODO LOQUE NO SE HA LOCALIZADOEN LAS TBLAS DE POSIONES.DESCARTADAS SERVICIOS SIN SI ni SO, HAYQUE TENER EN CUENTA ELNOMINAL COMPROMETIDO. NOS QUEDAMOS SOLO CON LOSCONTRATOS DEVO, FOND y CAMG BUSCAMOS LOS SERVICIOS(CONTRATO GEIN + ORDEN)ASOCIADOS A LOS FONDOSLOCALIZADO QUITAR QUITAR QUITAR FGEINCONFINVEXIFGEINCABNode 4Node 5FCONPRLNode 7Node 8Node 9Node 10HeaderNode 12Node 13FBOXSERCNode 15Node 16Node 17Node 18FBOXORDCNode 20HeaderConInbestNode 23FBOXORDDNode 26Node 28Node 29Node 30FTRFORDNode 32Node 33Node 34Node 36FINVMOVNode 38Node 39Node 40Node 53HeaderNode 55ConfigNode 65Node 66Node 67Node 68Node 69Node 70SeparamosAgrupamos por servicio y fondoNode 74Agrupamos por serv. y fondoNode 77Node 81Node 82Node 83Node 84Node 85Node 86Node 87Node 88Node 89Node 91Node 92Node 93Node 94Node 95Node 96Node 97Node 102Node 103Node 104Node 105Node 106Node 107Node 108Node 109Node 110Node 111Node 112Node 113Node 114Node 115Node 116Node 117Node 122Node 123Node 124Node 125Node 126Node 127Node 128Node 129Node 130Node 131Node 132Nominal x fondoNode 134Node 135Node 136Node 137Node 138Node 139Node 140Node 142Node 143Node 144Node 145Node 148Node 150Node 167Node 174Node 176Node 177Node 179Node 180Node 181Node 182Node 183Node 184Node 185Node 186Node 187Node 188Node 192Node 193Node 194Node 195Node 196Node 197Node 198Node 199Node 200Node 201Node 202Node 203Node 204Node 205Node 206Node 207Node 208Node 209Node 212Node 213Node 214CRUCE FINEXINode 217Sin InbestNode 223Node 224Node 225Node 249Cambiamos signoQuitamos CNUMORD 0FFONEXISeparamos DEVO y FONDECruce FONEXINode 264Node 265Node 267Node 268Node 271Node 272Node 274Node 283Node 284Node 285Node 287Node 291Node 292Node 293Node 294Node 295Node 296Node 297Node 298Node 299Node 300Node 301Node 302Node 303Node 304Node 305Node 306Node 316Node 318Node 319Node 320Node 321Node 323Node 324Node 325Node 326Node 327Quitamos los CREFORD = 0CRFORD igual a 0Node 332Node 333Node 339Node 340Node 341Node 342Node 343Node 344Node 347Node 349Node 350DESCARTAMOS SERVICIOSNode 358Node 363Node 365Node 366Node 367Node 368Node 369Node 376Node 1084DEVONode 1086Node 1087Node 1088Node 1089Node 1090Node 1092Node 1096Node 1097Node 1098Node 1099Node 1100FINVCARNode 1102Node 1103FONDE-CAMGNode 1105Node 1106Node 1107Node 1108Node 1109Node 1111PARALELO_SMNode 1113Node 1114Node 1115Node 1116Node 1117SeparamosTESTNode 1120Node 1122Node 1123Node 1124Node 1125Node 1126Node 1127CTIVO EN PERIODONode 1130Node 1131Node 1132Node 1134Node 1135Node 1136Node 1138Node 1141Node 1142Node 1143Node 1144Node 1145Node 1146COMPARA1COMPARA2COMPARA3Node 1150Node 1151DESCARTAMOS Node 1164Node 1166Node 1167Node 1168Node 1169Node 1170Servicios sin movimientosNode 1173DESCARTAMOS SERVICIOSNode 132Node 1176Node 1179Node 1180Node 1181Node 1182Node 1183Node 1184Node 1189FMOVFONDE_V2Cogemos F. OperNode 1200SeparamosNode 1210Node 1211Node 1214FCONCAMGNode 1216Node 1225FALLECIDOSNode 1243SALDO DIARIO NEG A CERONode 1249Node 1250Node 1251Node 1252Node 1253Node 1255Node 1256Node 1257Node 1258Node 1259Node 1260Node 1261Node 1262Node 1263Node 1264Node 1265Node 1266Node 1267Node 1268Node 1269Node 1270Node 1271Node 1272Node 1273Node 1274Node 1275Node 1305Node 1307Node 1308Node 1309Node 1310Node 1311Node 132Node 1313Node 1314Node 1315Node 1316Node 1317Node 1318Node 1320Node 1329Node 1335Node 1336Node 1337Node 1338Node 1339Node 1340Node 1341SALIDANode 1343FOTPSERNode 1366Node 1368Node 1369Node 1370Node 1371COMPARA4 CSV Reader CSV Reader CSV Reader Column Filter Column Renamer CSV Reader Column Filter Column Renamer Rule-basedRow Filter Column Renamer(Dictionary) Excel Reader Joiner Joiner CSV Reader Sorter Column Renamer Joiner Rule-basedRow Filter CSV Reader Column Renamer(Dictionary) Excel Reader Joiner Sorter CSV Reader Column Filter Joiner Column Renamer Column Filter CSV Reader Column Renamer Column Filter Joiner Sorter CSV Reader Column Renamer Joiner Rule-basedRow Splitter Column Renamer(Dictionary) Excel Reader Joiner Excel Reader Table Rowto Variable Sorter String to Number GroupBy Sorter Create Date&TimeRange Rule-basedRow Splitter GroupBy Sorter GroupBy Sorter Rule-basedRow Splitter Column Renamer Column Renamer Joiner Column Filter Column Filter Column Filter Concatenate Missing Value GroupBy Table Row toVariable Loop Start Rule-basedRow Filter Joiner Loop End Rule Engine Rule Engine Missing Value Moving Aggregator Extract TableDimension Table Rowto Variable Rule-basedRow Splitter Column Renamer Column Renamer Joiner Column Filter Column Filter Column Filter Concatenate Missing Value Rule-basedRow Filter Concatenate Rule Engine String to Date&Time GroupBy Joiner Rule Engine Rule Engine Concatenate Concatenate DuplicateRow Filter Column Filter Column Filter Rule Engine GroupBy GroupBy Joiner String Manipulation String Manipulation String to Number Number to String Joiner Column Renamer String to Number Math Formula Number to String String to Date&Time Rule-basedRow Filter Joiner Sorter Rule Engine String to Date&Time Rule Engine GroupBy Table Row toVariable Loop Start Rule-basedRow Filter GroupBy GroupBy Column Renamer Column Renamer Concatenate Joiner Rule-basedRow Filter Date&Time tolegacy Date&Time Time Difference(legacy) Table Rowto Variable Moving Aggregator Double to Integer Rule Engine Rule Engine Rule Engine Rule Engine Rule Engine Rule Engine Rule Engine Loop End DuplicateRow Filter Rule Engine Rule Engine Rule Engine Legacy Date&Timeto Date&Time Sorter Rule-basedRow Filter GroupBy Joiner GroupBy String Manipulation String Manipulation String to Number Number to String Concatenate String Manipulation Row Filter CSV Reader Row Splitter Joiner GroupBy Column Renamer String to Date&Time Number to String Concatenate Column Filter Column Expressions Time Difference(legacy) Date&Time tolegacy Date&Time Legacy Date&Timeto Date&Time Math Formula Rule-basedRow Filter Rule-basedRow Filter GroupBy Row Splitter Table Row toVariable Loop Start Rule-basedRow Filter Joiner Sorter Missing Value Loop End GroupBy String to Number Math Formula Math Formula String to Number Math Formula(Multi Column) GroupBy Joiner Column Filter Column Filter ConstantValue Column ConstantValue Column Column Renamer Column Renamer Concatenate SaldoMedio Row Filter Rule-basedRow Splitter Joiner Concatenate Joiner Column Filter Column Renamer Concatenate Missing Value Missing Value Row Filter Rule-basedRow Splitter GroupBy Rule-basedRow Splitter Rule Engine Format_Date Joiner String to Number Math Formula Number to String String to Date&Time Column Expressions GroupBy Joiner Column Expressions String Manipulation Rule-basedRow Splitter Concatenate Concatenate Missing Value Joiner GroupBy Column Filter ConstantValue Column GroupBy CSV Reader Joiner Column Renamer Joiner Column Expressions String Manipulation Concatenate ConstantValue Column Concatenate Concatenate CSV Reader Column Renamer Rule-basedRow Splitter Joiner Joiner Missing Value Rule-basedRow Splitter Rule-basedRow Filter String to Number Number to String String to Date&Time Math Formula(Multi Column) Rule Engine Rule Engine Rule Engine Rule-basedRow Splitter Rule Engine String to Date&Time Time Difference(legacy) Math Formula Legacy Date&Timeto Date&Time Date&Time tolegacy Date&Time Joiner Column Filter Concatenate Rule Engine Missing Value Math Formula Math Formula Excel Writer Excel Writer Excel Writer Sorter Sorter Rule-basedRow Splitter Math Formula(Multi Column) GroupBy Rule Engine Rule Engine Rule Engine GroupBy Joiner Format_Date Rule-basedRow Splitter GroupBy Concatenate String to Number Sorter Joiner Math Formula(Multi Column) Math Formula Math Formula DuplicateRow Filter CSV Reader Column Renamer Rule Engine Rule-basedRow Splitter DesagregaClacon Joiner Row Filter CSV Reader Column Renamer Rule-basedRow Splitter Excel Reader Joiner Rule Engine Rule-basedRow Filter GroupBy Joiner Rule-basedRow Filter Column Renamer Rule-basedRow Filter Rule-basedRow Filter GroupBy GroupBy Joiner GroupBy Joiner Rule Engine Rule Engine Rule Engine Column Filter Concatenate Rule Engine Rule Engine Column Filter Column Renamer Column Resorter Concatenate Concatenate Column Renamer Excel Writer Column Filter GroupBy GroupBy Joiner Joiner Format_Date GroupBy Concatenate DuplicateRow Filter String to Number GroupBy GroupBy Joiner Joiner Concatenate Rule-basedRow Splitter Math Formula(Multi Column) Joiner Rule Engine Rule-basedRow Splitter Rule Engine Concatenate Excel Writer Column Filter CSV Reader Rule Engine Rule-basedRow Splitter Rule Engine Rule Engine String to Number Excel Writer

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: Jordi
Created at: 2025-04-21
On NodePit since: 2025-10-26
Last update: 2025-10-27
Created with KNIME version: v5.2.0

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

Try NodePit Runner!