Forum Discussion

coreych's avatar
coreych
Regular Visitor
3 years ago

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...
Need Help
coreych's avatar
coreych
Regular Visitor
3 years ago

Ok, I ran the code exactly as you typed it...

#"Replaced Value" = Table.ReplaceValue(#"Removed Columns", each [Index], null, (x,y,z)=> {x, y, z}, {"Player IDs.IDFANGRAPHS"})

This code ran error free, but it does not appear to have done anything.  I'm looking at my table exactly as it was, and player 296 still has the same fangraphs ID as player 297, that incorrect fangraphs ID is 27646 showing for both of them instead of 16942 for player 296 and 27646 for player 297.

jbwtp's avatar
jbwtp
Memorable Member
3 years ago

Hi coreych,

 

the idea was that you will be able to check the parameters that are passed to the replacer funciton. If you can see the "ordinary" values in the Player IDs.IDFANGRAPHS column after executing this step, something clearly went wrong as it supposed to contant lists (containing the parameters passed to the replacer function), not text or numbers.

 

From this parameters you were expected to be able to see what exactly the filter needs to be.

 

Cheers,

John