I keep on getting all the columns an error like this "Expression.Error: The name 'Address Correction' wasn't recognized. Make sure it's spelled correctly."
= Table.AddColumn(#"Changed Type1", "Call Drivers", each Text.Combine(
{
Text.Combine({
#"Address Correction", #"Delayed Packages", #"Package Status", #"Package Received In Error", #"Reattempt", #"Delivery Issue", #"Support Ticket", #"Return to Sender", #"Location", #"Label", #"Vacation Hold", #"Drop Off", #"Money Back Guarantee", #"Claims", #"Hold at Location", #"Domestic Claims", #"International Claims", #"General Inquiry", #"International Shipments", #"FedEx Delivery Manager", #"Other/s", #"Call Tag", #"Complaints", #"Delivery Instructions"
}, ","),
Text.Combine({
#"Ground Pickup", #"Express Pickup", #"Missed Pickup"
}, ","),
Text.Combine({
#"Appointment Delivery", #"Billing/Invoice Inquiry", #"Delivery Issue1", #"Disputes Delivery", #"LTL Pickup", #"Pickup Cancellation", #"Pickup Status", #"Quote", #"Shipment Inquiry"
}, ","),
Text.Combine({
#"Express Domestic Pickup", #"Express Domestic Pickup Status", #"Express Domestic Rating", #"Express Domestic Tracking", #"Express International Pickup Status", #"Express International Tracking", #"International Pickup", #"International Rating", #"International Shipment Inquiry"
}, ","),
Text.Combine({
#"Appointment Delivery1", #"Shipment"
}, ","),
Text.Combine({
#"Invoice", #"Rates"
}, ","),
#"Level 1 Location Call Driver",
#"Level 1 Supplies Call Driver"
}, ",")
)
I have already double checked the names on my source it has the correct spelling with no white spaces. Below is the code.
No syntax errors have been detected, it's just it couldn't recognize the columns.
I have fixed this. Thank you!
For some reason some of the columns had whitespacs and other columns for example like the name "Billing/Invoice Inquiry" which did not read very well so I had to rename it to "billing_invoice_inquiry". It works now.