python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - pentaho-spoon

What would be the correct XPath to obtain counterparty with same tag name?

I am trying to figure out what the correct XPath would be to obtain information from this XML doc. <relationships> <relationship> <person> <name>Jane Do...
test-img

moonlight-hollow

xml

xpath

pentaho

kettle

pentaho-spoon

Votes: 0

Answers: 1

Latest Answer

Probably this example is too much simplified, so my answer needs more work with your real data, but what I would do is to get the two rows related to person: Person Role Jane Doe Customer Jo...
test-img

Ana GH

Using multiple wildcards in Pentaho spoon for subdirectory paths

I was trying to use the GetFiles step to retrieve all files that are type .xlsx having sheet in the filename and having common names in the subdirectories path. example directory contents: c:\DATA\a1 ...
test-img

CPHILLIPS1234

wildcard

pentaho

pentaho-spoon

pentaho-data-integration

Votes: 0

Answers: 1

Latest Answer

Using data from previous step, you should send input data with those parameters, in each row set the directory and exten: EXAMPLE CREATE TABLE test( diretory TEXT, exten CHARACTER VARYING(15) ) INSER...
test-img

DeathX

Merge Join/Stream Lookup Pentaho Issue

I've got this question: I've got two sources in SOURCE and COMPARISON and i've tried a Merge Join Step / Multiway merge join (in INNER option) / Stream Lookup. the image shows what I am facing. [Issue...
test-img

putrakurniadi

sql

pentaho

pentaho-spoon

pentaho-data-integration

Votes: 0

Answers: 1

Latest Answer

You have duplicates in your COMPARISON table, so you'll need an Unique rows step before the Join step to be sure you only get one row for the A2-B2-C2-D2 key. The unique rows also needs the streaming ...
test-img

Ana GH

Database Lookup Cache in Pentaho

Lately, I have seen Pentaho behaving strangely as it sometimes doesn't return the correct value as a lookup result. I have enabled cache in the lookup steps. How can I clear the cache once in a while...
test-img

Nikhil

pentaho

kettle

pentaho-spoon

pentaho-data-integration

Votes: 0

Answers: 2

Latest Answer

Why don't you disable cache(Uncheck box)? Why don't you use another step like merge join, lookup?
test-img

VietnamDataEngineer

Posts

Questions

Blogs

Jobs