CODEWITHSUNDEEP
pentahokettledata-integration
newbie
newbie

Reputation: 61

Why Pentaho Data-integration cannot read new field on table?

I am trying to copy record from a few table into a new one(report_table). But when I've created the transformation on kettle, I need to add a new field into report_table. After I add the field, kettle wont show it. When I try to "enter field mapping", it does not show on 'target field' Why cant kettle read the field?

There's no special thing. I just put "Input Table" and give it a query to select from my resource table. Then I put "Output Table" and give a "Hop" between input and output table. Then when I choose "Enter field mapping" kettle can't read all field from target table.

Any idea.

Upvotes: 1

Views: 5171

Answers (1)

Codek
Codek

Reputation: 5164

Clear the database cache. PDI caches the database structure, and also the hop metadata.

Also, i've seen bugs in 5.0.x where it gets into its head the structure of the metadata and will not change until you restart spoon. So try that too! (Note this only happens occasionally in my experience, and I work with PDI all day every day.

Upvotes: 4

Related Questions