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
Solved! Go to Solution.
Hey @Hemraj_ash
Have you tried Auto-Field & Data-Cleanse?
Autofield will choose the field type and Data Cleanse will trim, convert nulls etc
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