Hi
I have following code that works perfectly:
let
Source = Oracle.Database("oracledatabase1.world", [HierarchicalNavigation=true, Query="SELECT /*+ LEADING A) */
#(lf)A.ANOM1,
#(lf)A.ANOM16,
#(lf)A.ANOM2,
#(lf)A.ANOM3,
#(lf)B.ANOM4,
#(lf)B.ANOM5,
#(lf)C.ANOM6,
#(lf)D.ANOM7,
#(lf)D.ANOM8,
#(lf)D.ANOM9,
#(lf)D.ANOM10,
#(lf)D.ANOM11,
#(lf)E.ANOM12,
#(lf)E.ANOM13,
#(lf)F.ANOM14,
#(lf)G.ANOM15
#(lf)FROM
#(lf)BOARD A INNER JOIN ANOMBOARD1 B ON A.ANOM17=B.ANOM17
#(lf)INNER JOIN ANOMBOARD2 C ON B.ANOM5=C.ANOM6
#(lf)INNER JOIN ANOMBOARD3 D ON C.ANOM6=D.ANOM7
#(lf)INNER JOIN ANOMBOARD4 E ON A.ANOM16=E.ANOM12
#(lf)INNER JOIN ANOMBOARD5 F ON C.ANOM6=F.ANOM14
#(lf)INNER JOIN ANOMBOARD6 G ON F.ANOM14=G.ANOM15
#(lf)WHERE A.ANOM3 BETWEEN TO_DATE('"&StartDateA&"', 'YYYY/MM/DD') AND TO_DATE('"&EndDateA&"', 'YYYY/MM/DD') AND E.ANOM13 = "&VARIABLE1&""]),
#"Added Index" = Table.AddIndexColumn(Source, "Index", 1, 1, Int64.Type)
in
#"Added Index"
Now i want to add one more filter to SQL command
let
Source = Oracle.Database("oracledatabase1.world", [HierarchicalNavigation=true, Query="SELECT /*+ LEADING A) */
#(lf)A.ANOM1,
#(lf)A.ANOM16,
#(lf)A.ANOM2,
#(lf)A.ANOM3,
#(lf)B.ANOM4,
#(lf)B.ANOM5,
#(lf)C.ANOM6,
#(lf)D.ANOM7,
#(lf)D.ANOM8,
#(lf)D.ANOM9,
#(lf)D.ANOM10,
#(lf)D.ANOM11,
#(lf)E.ANOM12,
#(lf)E.ANOM13,
#(lf)F.ANOM14,
#(lf)G.ANOM15
#(lf)FROM
#(lf)BOARD A INNER JOIN ANOMBOARD1 B ON A.ANOM17=B.ANOM17
#(lf)INNER JOIN ANOMBOARD2 C ON B.ANOM5=C.ANOM6
#(lf)INNER JOIN ANOMBOARD3 D ON C.ANOM6=D.ANOM7
#(lf)INNER JOIN ANOMBOARD4 E ON A.ANOM16=E.ANOM12
#(lf)INNER JOIN ANOMBOARD5 F ON C.ANOM6=F.ANOM14
#(lf)INNER JOIN ANOMBOARD6 G ON F.ANOM14=G.ANOM15
#(lf)WHERE A.ANOM3 BETWEEN TO_DATE('"&StartDateA&"', 'YYYY/MM/DD') AND TO_DATE('"&EndDateA&"', 'YYYY/MM/DD') AND E.ANOM13 = "&VARIABLE1&" AND F.ANOM14 ="row value as text""]),
#"Added Index" = Table.AddIndexColumn(Source, "Index", 1, 1, Int64.Type)
in
#"Added Index"
And i get error "Expression.SyntaxError: Token Comma expected."
What I am doing wrong? I see if make a variable, and use that as filter it works, but this time i want to filter by row data value.
