Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey,
I currently try to see the new field in the query editor which where inserted throughout a Jason.
Attached you can see an extraxt from the advanced editor:
let
Source = Json.Document(Web.Contents("xx")),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Ignore),
#"Expanded Columns" = Table.ExpandRecordColumn(#"Converted to Table", "}),
#"Renamed Columns" = Table.RenameColumns(#"Expanded Columns",Table.ToRows(pipedriveFieldTranslator)),
#"Renamed Columns1" = Table.RenameColumns(#"Renamed Columns",{{"person_name", "contactPersonName"}}),
#"Changed Type" = Table.TransformColumnTypes(#"}}),
#"Replaced Value" = Table.ReplaceValue(#"Changed Type","104","Partner",Replacer.ReplaceText,{"jobCategory"}),
In this format it approximately looks like.
The error message I am getting is :
Expression.Error: We expected new Column Names to have the same number of items as field Names.
I
Hi @PaulineB,
Did you insert any step in the middle of the queries? Can you share a sample please? There are some syntax errors. But it won't relate to the error in this post.
Best Regards!
Dale