Want to create macro which will clean all column dynamically

[Hemraj_ash]

Hi All,

I want to create macro which will clean all column values dynamically.

Let me give one scenario.

I have data which need to prepare first so same table we are getting in multiple workflow.

i don't  want to clean one by one column manually using tool instead i would like to create one macro where i will feed all column  automatically and it will detect string and integer column and accordingly will clean data.

Now cleaning activity means :

ex : convert null to 0

       trimming space of string value

       etc.

Any help with attaching workflow file with reply would be appreciate .

Thanks,

Hemraj

[LordNeilLord]

Hey @Hemraj_ash 

Have you tried Auto-Field & Data-Cleanse?

Autofield will choose the field type and Data Cleanse will trim, convert nulls etc

[GiuseppeC · Accepted solution]

Hi @Hemraj_ash,

the Multi-field tool allows you to apply the same formula to multiple columns, depending on their type.

If you use it within a macro and keep the "Dynamic or Unknown Fields" checkbox checked, you should be able to get what you want.

Hope this helps!

Giuseppe