Hi Team,
If I try to input attached txt file I dont get the correct columns and data.
Can you help me where the issues is?
Best regards,
Pascal
yeah, sorry about the version issue. it happens. The quick fix is to right-click on the workflow file (.yxmd) and edit in notepad. the second line controls the "version" of the file.
i'll change it to 2019.1 and save, assuming you are on a version after that one and it should open just fine.
Here's the updated Workflow
looks a bit dirty to me, so i would go a cleansing route outside of the input tool.
Set file format to .csv
set Delimiters to \0 (no delimiter)
deselect "first row contains field names"
increase field length to 5000 so it isn't truncating the data.
then add a text to columns tool and parse on \t (tab-delimited)
set number of columns to 50 and you'll see extra "fields" if you scroll over to the right after running the workflow.
@jarrod: Thank you for you help: So the Input file is now csv. Can you please check the settings for me?
Somehow it still is not correct.
The point with the extra "field" is also not clear to me.
Thank you for your support.
Regards,
Hello @jarrod ,
I've built a little solution which can be used regardless the number of input columns.
Regards
I do love this method @afv2688 . thanks for posting it. One tweak i would make is change "concatenate" to "First" in the Cross Tab tool - it's more performant and shouldn't matter for this use case since each value should be unique (1:1 field to row relationship).
