Hello,
I have a rather simple problem where I have a system parameter file.
Where the delimiter is '.' (i.e. Fullstop).
However this is not recognised by the Dynamic Input tool, when '.' is specified as delimiter.
On clicking the REFRESH button, and hoping to preview the separated columns, only the first line is displayed. i.e. sysparm
Can anyone please advise. I have attached the sysparm txt file below.
Thank you
Paul
Solved! Go to Solution.
Your first row only has one field name.
Trying to import the entire file, with row 2 having more fields, results in an error (record 2 has too many fields).
Try the import starting on line 2, and leave the box un-checked for First Row Contains Field Names.
Then use a Select or some other tool, like Dynamic Rename, to supply the field names.
Chris
Many thanks Chris.
Yes that makes sense, that the first row has 1 field.
and importing from row 2, solves this.
This Alteryx community is fantastic and supportive !!
All the best
Paul
Thanks Sntrada, I used the read from line 2 in the dynamic input. and it resolves the problem.
All the best
Paul