Forum Discussion
Dataflow refresh fails due to conversion error
Solution SageYou should be able to...I just connected to a folder New Folder and it generated the following. Add steps you want applied to each file (provided they have the same structure) to the "Transform Sample File" step...probably after Promoted Headers step.
Hi Jeff,
Yes I tried adjusting the helper queries, but not with succes. If in the first screen you get after you click on "combine files" you select "Based on first 200 rows" your data type detection already determines it is a number column, and uses that to make the helper querries. However my number column has text somewhere after row 200 and thus it fails. The only thing that worked for me is to use "Do not detect datatypes" as shown in picture two. But then for every file it adds to your table you get a row simmilar to row 1 in the second picture. Not ideal, but easy to filter out.
If you still think it should be possible i might try it again, but with validating my flow and refreshing it, it is very time consuming to do this trial and error wise.
Kind regards,
Luca
- jeffshieldsdev
Can't you edit the Changed Type step or whatever in the helper query? Change the step to treat u_windows_linux_server.os_version as Text?