Dynamic resize strings larger than 65535

Question

Hi

I am trying to prepare various tables to upload to redshift. The limitation that I am trying to solve is redshift won't accept v_wstrings larger than 65535. I am trying to create a workflow that accepts any table as input, resizes any strings larger than 65535 (truncating the data is fine), then output the table with the all fields types unchanged expect for the large strings.

Any ideas?

Thanks,

Travis

ddiesel · Accepted Answer

Hi @travis

I had to do something similar recently and I used the Dynamic Replace tool. I'm sure there might be a cleaner solution, but here's what worked for me:

(I used 20 as the field length instead of 65535 in this example.)

Good luck. Hope this helps!