Hi,
Is there any dynamic way that I can convert all the string fields to blob? The Blob Convert tool only allows one field at each time. I am thinking of using iterative macro maybe? Any help is appreciated!
I actually took a slightly different approach. What do you think about this? I used a transpose tool on the data to get all columns into a name and value column, then used the convert to blob tool, and then cross tabbed back.
You could use a batch macro where you pass in all of the field names via control parameter so that you could mass convert all columns to blobs.
@BrandonB could you share your sample workflow? Thanks!
