Forum Discussion
kasiaw29
7 years agoResolver II
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
- v-chuncz-msftCommunity Support
- kasiaw29Resolver II
Thank you for pointing this out. This worked! Thanks!