Forum Discussion

philliperamos's avatar
philliperamos
Contributor
6 years ago
Solved

Populate Aggregate snap with Pipeline Parameter

So I’d like to use the value of a pipeline parameter as the field in the Aggregate snap. Can this be done, and if so, how?
  • koryknick's avatar
    koryknick
    6 years ago

    Specify the field name, including “$” in the pipeline parameters:

    Then use the “eval()” function in the Aggregate snap:

    This doesn’t set the result field name, but that can be done in a subsequent mapper if needed.

jaybodra's avatar
jaybodra
New Contributor III
7 years ago
Copy LinkReport

@virender.prajapati I have seen this happening to me in MySQL. I used toLocalDateTimeString() function before inserting it into the DB and worked fine.

You can try this in your mapper,
Date.UTC(Date.now().minusMonths(1).getFullYear(),Date.now().minusMonths(1).getMonth(),0).toLocaleDateTimeString({“format”: “yyyy-MM-dd HH:mm:ss”,“timeZone”:“UTC”})

You can also look into oracle jdbc url properties