This discussion is archived
2 Replies Latest reply: Jan 20, 2013 8:54 AM by 984374 RSS

ODI evaluate variable

aetl Explorer
Currently Being Moderated
Hi everyone,

I have a question about evaluate variable:

Now For example I have a variable:

Name:#VAR_FILE_NAME
--Text
-No history

İn select -----Select first_name from hr.employees where employee_id=106 (it returns 'Valli')

Then Second variable:

Nanem=#VAR_CONTROL
--Text
--No history
Select--- SELECT '#VAR_FILE_NAME' from dual where substr('#VAR_FILE_NAME',1,1)='V'


Now in my package #VAR_FILE_NAME is refreshing variable

#VAR_CONTROL is evaluate variable and compare condition is ='#VAR_FILE_NAME'

if true then write a table else write false table.

I want to compare two string.

But always it is going to false table

Where Did I made mistake?

Thanks your reply

Regards

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points