Multiple values "Column Name is like" in Transformation Scope

[edward221096]

Hi Community,

I am creating a Global Transformation Rule and under the Transformation Scope there is a "column name is like". I want to include FirstName% and LastName% so I will not create a multiple Global Transformation Rule. Is this possible? I already tried the following values but it is not working:

1. FirstName%, LastName%

2. FirstName% LastName%

3. FirstName% || LastName%

4. FirstName% and || LastName%

[SwathiPulagam · Accepted solution]

Hi @edward221096 ,

There is no option in Global transformation for selecting multiple columns under the "column name is like".

Technically, you can keep only one like condition under the "column name is like".

Thanks,

Swathi

[Heinvandenheuvel]

KISS

Just create two (appropriatly named) global transformations, one for First an other for Last.

Personally I'd gamble - Just one transformation for  %stName%

I'd trust that to be tight enough, but I'd verify in the source DB to list owner.table.column where column_name like '%stName%'  🙂

Hein

[lyka]

Hello,

Please let us know if any of the suggested solutions worked for you

Thanks

Lyka

[Heinvandenheuvel]

I looked at this again, but you _can_ operate on multiple column names with one rule.

In the UI, after:Data type is: Any

There is: Advanced options
Scope expression:
($AR_M_SOURCE_COLUMN_NAME == 'name1') or ($AR_M_SOURCE_COLUMN_NAME=='name2')

Resulting in:

Rename column
	for %.% with column %
	Scope expression: ($AR_M_SOURCE_COLUMN_NAME == 'name1') or ($AR_M_SOURCE_COLUMN_NAME=='name2')
	to lower($AR_M_SOURCE_COLUMN_NAME)

Many other expressions are possible to be used here. 

Hein.