Forum Discussion

Georgie_stanley's avatar
Georgie_stanley
New Member
1 year ago

E0f error

Hi, how do I fix this error? 

 

let
Source = Json.Document(Web.Contents("https://dominowb.sharepoint.com/sites/WestonBeamor/Shared%20Documents/Plannerdata.json")),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"taskid", "taskname", "task description", "taskprogress", "taskstart", "taskdue", "taskcomplete", "assignees", "subtasks", "buckets", "awaitingstones", "straighttocad", "xmas", "resinrequest", "missinginfo", "urgent", "awaitingengagementring", "cancelled", "sketch", "cadoutworker", "inunsetting", "inscanning"}, {"taskid", "taskname", "task description", "taskprogress", "taskstart", "taskdue", "taskcomplete", "assignees", "subtasks", "buckets", "awaitingstones", "straighttocad", "xmas", "resinrequest", "missinginfo", "urgent", "awaitingengagementring", "cancelled", "sketch", "cadoutworker", "inunsetting", "inscanning"}),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Column1",{{"taskid", type text}, {"taskname", type text}, {"task description", type text}, {"taskprogress", Int64.Type}, {"taskstart", type datetime}, {"taskdue", type datetime}, {"taskcomplete", type any}, {"assignees", type any}, {"subtasks", type any}, {"buckets", type any}, {"awaitingstones", type any}, {"straighttocad", type any}, {"xmas", type any}, {"resinrequest", type any}, {"missinginfo", type any}, {"urgent", type any}, {"awaitingengagementring", type any}, {"cancelled", type any}, {"sketch", type any}, {"cadoutworker", type any}, {"inunsetting", type any}, {"inscanning", type any}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"assignees", "subtasks"}),
#"Expanded buckets" = Table.ExpandListColumn(#"Removed Columns", "buckets"),
#"Expanded buckets1" = Table.ExpandRecordColumn(#"Expanded buckets", "buckets", {"bucketName"}, {"bucketName"}),
#"Removed Columns1" = Table.RemoveColumns(#"Expanded buckets1",{"taskcomplete", "taskstart"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Removed Columns1",{{"taskdue", type date}}),
#"Added Conditional Column" = Table.AddColumn(#"Changed Type1", "Task Status", each if [taskprogress] = 0 then "Not Started" else if [taskprogress] = 50 then "In Progress" else if [taskprogress] = 100 then "Complete" else null),
#"Added Custom" = Table.AddColumn(#"Added Conditional Column", "Overdue", each if ([taskdue] <> null and [taskprogress] <> 100 and [taskdue] < DateTime.Date(DateTime.LocalNow()) ) then "true" else "false"),
#"Changed Type2" = Table.TransformColumnTypes(#"Added Custom",{{"Task Status", type text}, {"Overdue", type text}}),
#"Filtered Rows" = Table.SelectRows(#"Changed Type2", each [taskid] <> null and [taskid] <> ""),
#"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each [taskname] <> null and [taskname] <> "")
in
#"Changed Type",
Output =
Table.View(
null,
[
GetType = () =>
type table [taskname = Text.Type],
GetRows = () =>
GetData(),
OnTake = (count as number) =>
if count=0
then
#table(type table [taskname = Text.Type], ()
else
GetData()
]
)/*,
BufferedOutput = Table.Buffer(Output)*/
in
//GetData()
Output
//BufferedOutput

Need Help

4 Replies

    • Georgie_stanley's avatar
      Georgie_stanley
      New Member
      1 year ago

      The error comes up as Eo7 and it highlights the comma after #"Changed Type", 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi shreebidwai 

    It has the error in the following part.

    in
#"Changed Type",
Output =
Table.View(
null,
[
GetType = () =>
type table [taskname = Text.Type],
GetRows = () =>
GetData(),
OnTake = (count as number) =>
if count=0
then
#table(type table [taskname = Text.Type], ()
else
GetData()
]
)/*,
BufferedOutput = Table.Buffer(Output)*/
in
//GetData()
Output
//BufferedOutput

    In the 'in' part, you can only return to the steps in the let part. If you add other content after the 'changed type' in the 'in', it is not possible. You can treat this part as a step, just in the 'let' and finally return this step in the 'in'

     

    e.g

    let
output=....
in 
output

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.