0

Suppose, I have set multiple variables in pentaho with values like following picture:

enter image description here

I have set it in global variable like : $YYYYMMDD:DD-1, $YYYYMM00:DD-1,...

Now, I have a table named 'xyz' with var_item column having records like:

enter image description here

How do I set value of those variables to records of var_item column, then insert those values to new column in 'xyz' table ?

The result I expecting like following pic:

enter image description here

nbk
49.7k8 gold badges32 silver badges53 bronze badges
asked Nov 29, 2024 at 4:37
2
  • please read meta.stackoverflow.com/questions/285551/… and edit your question Commented Nov 29, 2024 at 4:45
  • When you talk about "variable", do you mean "Parameters", from a transformation ? Can you please be more specific on the data you have and the result you want from it ? (You want to join a table ? From SQL ?) Commented Nov 29, 2024 at 15:05

0

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.