Forum Discussion
Changing Data Source of Transform Sample File
Hello and thank you for the response, the trouble is that when I change the source path of the Sample File, the 'Transform Sample File' step encounters this error message:
An error occurred in the ‘Sample File’ query. Expression.Error: The key didn't match any rows in the table.
Details:
Key=Record
Table=Table
Hello, they are identical. I literally created a duplicate of all the source files so the only difference is a slight change in a folder name.
Dan
I know this string is old but thought I'd add something I found while looking at the Sample file. I looked at the Transformation Sample File / Applied Steps. I noticed the Changed Type step had type "Int64.Type" while in my main query I had "type text" for the same column where the errors were occuring. This seemed to fix the problem.
Hello, the privacy levels for the current file are already set to 'Ignore the Privacy Levels and potentially improve performance' if this is your proposal...?
Dan