So cool to see the variations from everyone!! When I demo'ed this in our User Group meeting a month or so ago, I had a solution all prepared (in case there were crickets in the room). We ended up coming up with something totally different as a group... and then when I went through it again this time, focusing on creating the app version, I came up with yet another way to get to the same answer. Go figure! Gotta love how Alteryx even makes you rethink the path to a problem you came up with... :)
Thank you, @JoeM, for the chance to be on the other side of the challenge for a change! And I am, as always, in awe of the innovative answers received... Cheers, everyone!
Cheeky bit of text parsing.
I have added all the tableau file extensions in the file extensions for attachments:
.twb .twbx .tds .tdsx .tde .tbm .tms .tps
These ones were missing before: .tbm .tms .tps
Is there another extension that we are not aware and needs to be added?
By taking a look at how others solved this problem, I realized that the text document came with invisible break lines that helped separating the rows; I found it a lot easier separating two chucks by the only comma within each row; on this way, I could get the 3 fields on one side and the remaining fields on the other side.
I did not complete the application but noticed that depending on the text pulled, there were 5 or 6 columns of value information; some files did not list the 6th value column.
@alex Please can you give us the extension of the file that you are trying to upload and its size? Can you also let me know what browser do you use for uploading it. Thanks for your patience.
@alex Sorry that you are still having this issue. I tested attachments with these two types of files and I did not see any issues on this board and on the community. I sent you a PM. May be we can try to solve it via a Webex call. I will be pleased to help you and finally determine what is causing this issue. Thanks