This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
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.
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?