Fetch Column Name in BODS function

[former_member424515]

Hi Experts,

Is there any way by which we can fetch the Column name in custom function. I want to use column name name for some comparison purpose.

Thanks,

Ankit

[Former Member · Accepted solution]

Hi Ankit,

This might help you, are you looking for this..?

It is possible to get column names of a table using data dictionary tables of a database and it can also be loaded into table as a row.

It can done using either scripts or SQL transformation.

Using Script:

     output:

Now you can use the global variable in query transformation with word_ext function to load it into separate columns in table.

Or you can use global variable directly in  ifthenelse statements to validate your condition with help of word_ext function.

Using SQL tranformation:

Use this SQL query in transformation : select COLUMN_NAME from all_tab_columns where table_name = 'table_name' and use pivot transformation to load this column as row in a table.

Let me know your exact query, so that i will also try if i can...

Thanks,

[former_member424515 · Accepted solution]

Thanks Pradheep good idea.

Will Implement this and get back to you if need more info.