Forum Discussion

kasiaw29's avatar
kasiaw29
Resolver II
7 years ago
Solved

Token Comma expected

Hi all. This is my first post so I'm hoping to get this right. 

 

I've removed a piece of code by accident and I'm getting the following error of Token Comma expected. I go to show error and it highlights the piece and I insert a comma before it but this doesn't solve it. 

Any extra piar of eyes would be really useful here. Pleasae

 

let
    Source = Oracle.Database("mysource", [HierarchicalNavigation=true, 
Query="select 
#(lf)#(lf)lead_id, 
#(lf)#(lf)creation_date, 
#(lf)#(lf)name,
#(lf)#(lf)country, 
#(lf)#(lf)stage_id,
#(lf)#(lf)main_representative_id, 
#(lf)#(lf)cf$_region_desc Region,
#(lf)#(lf)cf$_sector_desc Sector,
#(lf)#(lf)source_id,
#(lf)#(lf)cf$_source_detail2,
#(lf)#(lf)cf$_district_desc District#(lf)

#(lf)#(lf)from ifsapp.business_lead_cfv#(lf)#(lf)
#(lf)where source_id_db in ('INTR','BUSDEV')#(lf) 

#"Renamed Columns" = Table.RenameColumns(Source,{ {"MAIN_REPRESENTATIVE_ID", "Lead Representative"}, {"REGION", "Lead Region"}, {"LEAD_ID", "Lead ID"}, {"SECTOR", "Lead Sector"}, {"STAGE_ID", "Lead Status"}, {"DISTRICT", "Lead District"}, {"CREATION_DATE", "Lead Creation Date"}, {"COUNTRY", "Lead Country"}, {"CF$_SOURCE_DETAIL2", "Lead Source Origin"}, {"SOURCE_ID", "Lead Source ID"}, {"NAME", "Lead Name"}}) in #"Renamed Columns"

 

2 Replies