pentahokettlepentaho-spoonpentaho-cdepentaho-data-integration
How to map input to output fileds from excel to csv in pentaho?
How to map input to output fileds from excel to csv in pentaho?
How to tranform this in pentaho ? Where to map values of input to output columns as the positions and name are different in input to output.
Solution
You can rename the fields right in your MS-Excel-Input step, and you can reorder the fields in Text-File-Output. Also, a Select-Values step allows you to rename and reorder fields in one sweep on the Select & Alter tab.
- How do I clear the cache in Pentaho Data Integration
- What is the difference between data integration softwares and ESB?
- Create a near real time DWH with Pentaho Community edition
- Set the charset for Firebird connection from Pentaho DI
- "RecursionError: maximum recursion depth exceeded" from ssl.py: `super(SSLContext, SSLContext).options.__set__(self, value)`
- Pentaho Data Integration Community Edition 9.4 - Shared objects file feature of transformation doesn't support variable
- Pentaho Data Integration 9.3 - Postgres Incremental load
- How to find unique values from set of rows using pentaho kettle?
- How to add zero in front of single digit values using REGEX in pentaho
- Pentaho File Repository Moves Jobs & Transformations to root
- Use a field from a previous hop as a parameter in a Table input using Pentaho Kettle
- Pentaho kettle Can't run transformation due to plugin missing
- Waiting for Transformations in a Job
- Pentaho CDE: Is there a way to debug the sql command being executed?
- Pentaho Kettle replace cell value if value exists in other two columns
- Git Not In Sync with Local Branch
- How to find where KETTLE HOME is defined
- REST API calls through Pentaho Data Integration (Spoon)
- Pentaho PDI || Windows Current User
- Pentaho check if at least one row LDAP is 0
- Get row number from stream to perform concat
- How input data in line chart in Pentaho?
- Pentaho-carte rest api?
- How to run Pentaho transformations in parallel and limit executors count
- Pentaho to kill all running transformations if any one them fails
- Pentaho Business Inteligence Automation
- How to delete rows which were deleted in source table (Pentaho data integration)
- Pantaho MySQL 8 connection error Driver class 'org.gjt.mm.mysql.Driver' could not be found
- No MongoDB option in Pentaho
- Pentaho metastore location when connecting to repository