Dynamic Input Truncating My Precious Data!

[brianscott]

Hey everyone - 

Got me some big old nasty files from dynamic input and the data is such that I really need to transpose it.  But when I do, it comes out of the tool as a string 254 and I lose characters sometimes and this fills me with a terrible sadness.  How can I triumph over this senseless loss of data?

brian

Edit:  I had some sloppy json files and used dynamic input to grab 'em.  Json input wouldn't work because Alteryx complained about structure, so I went with importing with .CSV and using a \0 as a delimiter as suggested on the internet.  Did not error out, but did have a soft failure ala truncating my precious json string.  So, instead of importing as .csv, I imported as ASCII flat file, set my line definition to be one big fat line 2500 characters long, checked the 'allow long lines' checkbox and let fly.  It works. 

[Storm · Accepted solution]

I don't have a ton of workflows using transpose tool; but I tested just now, with a string from input text tool.  String in input was 370 characters of gobbledegook; and coming out the transpose tool it was all still there.  Are you sure your truncation isn't happening elsewhere?

[brianscott]

You are right!  (will try to modify title).

But now, the dynamic input tool is the character thief!  I'll kick the tires there for a while before asking for more help. 

Thanks.

brian