Cascade trim to multiple columns

sumesh.abraham · Post by **sumesh.abraham** » Mon Mar 10, 2008 5:56 am

Dear All,

I want to apply Trim function in the transformer for 65 columns. I was looking for any functionality in PX where I can specify Trim for one column and let it be cascaded to other columns. Do we have anything like that? Any help on this would be appreciated.

Cheers,
Sumesh

ray.wurlod · Post by **ray.wurlod** » Mon Mar 10, 2008 6:12 am

Select all the columns you want to apply the function. With them selected right click and choose Derivation Substitution from the menu. In the field at the bottom enter Trim($1) and click OK, then Yes to All.

pandeesh · Post by **pandeesh** » Mon Apr 18, 2011 12:12 am

Hi,

Does this shortcut work in server jobs?

Thanks in advance

ray.wurlod · Post by **ray.wurlod** » Mon Apr 18, 2011 1:34 am

Yes. Wouldn't it have been so much easier to try it?