Text String Truncated

[kaushik_birmiwal]

Hi All,

I have been facing a strange issue. I am running a batch macro to combine multiple files (using joins and unions). 

For one file Alteryx processes the entire contents of the cell, while for another file, it truncates the cell contents (for the exact same text) - the LEN of text doesn't exceed 300 in bot hcases. I have set the Type as "V_WString" and Size as "1073741823". Still I continue to face the same issue. 

Has anyone else faced the same issue or has the solution to this problem? 

Thanks,

Kaushik

[danilang]

Hi @kaushik_birmiwal 

Can you provide a small sample of the 2 tools and the macro you use to combine them?

Dan

[ashissanpui · Accepted solution]

Could you check if in-between the process you are changing the type of that specific field?