Posts by Cristian Curti • 186 points
5 posts
-
1
votes2
answers319
viewsA: Get all the content I don’t want via Regex
Since you are using Pentaho, and the CNPJ is always at the end of the String, you do not need to use complicated Regex that because of 1 character wrong may not work. Use a step Formula with the…
-
1
votes2
answers1611
viewsA: Pentaho Data Integration repository does not appear in PDI
For me the following solution worked. Close your PDI, Navigate to the following folder of your PDI installation: ..\data-Integration system Karaf caches Spoon\ There may be date-1, data-2 folders…
-
1
votes1
answer303
viewsA: Problems importing data with Microsoft Excel Input
If you are using Step Table Output to perform the Insert, remember that if you do not specify where each column should be inserted, Pentaho will behave assuming that the received table is in the…
-
0
votes2
answers989
viewsA: Pentaho Data-Integration
Through JOB STEP there are not many filters to be used, but it is possible to list the files of an FTP using step Get File Names in conjunction with VFS (Virtual File Systems), this way you can…
pentaho-kettleanswered Cristian Curti 186 -
1
votes1
answer287
viewsA: Insertion of foreign keys by the kettle
You are using multiple input sequences: Excel input - Table input - Table input - Excel input - Table input Each time an input step is used in the flow, the resulting table of this input is reset,…