Here's a distilled version of what we're trying to do. The transformation step is a "Table Input": SELECT DISTINCT ${SRCFIELD} FROM ${SRCTABLE} We want to run that SQL with variables/parame...

i have a json structure like that, where i would like to take from the json path the "id", but when i run the JSON input method in pentaho, putting "$..id" as the path, it returns ...

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 ...

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...