Forum Discussion
Error when applying schema with nullable records
I am getting errors on Record type objects when I try to apply a schema in my custom connector even though I have added the nullable type identifier. The below example shows whenever I have location...
Hello JoeFields - you need to add a step in your query (before the point at which the error is thrown) which converts null values into empty records so that the field can be evaluated like a record, like this:
Table.TransformColumns(Source, {{“Column1”, each if Value.Is(_, type record) then _ else [a=_] }} )