Forum Discussion
If then statement, invalid identifier
Hi all, I'm working with a database of baseball players. I need to match the contracts in my fantasy baseball league with the season projections I want for each player. The season projections datab...
Hi coreych,
This is Ok, the field can be text, it should not be a problem.
Did you try this version of the replacer? What it returns on the "296" lines?
You can try using this knowledge for tweaking the actual replacer code.
Cheers,
John
I don't really understand what the x,y,z is doing. I think you wanted me to replace that with the values. I wrote it this way and it returned the "invalid identifier" error on the first "16942" parameter.
...
#"Replaced Value" = Table.ReplaceValue(#"Removed Columns", each [Index], null, (“16942”,296,null)=> {“16942”, 296, null}, {"Player IDs.IDFANGRAPHS"})