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

Thanks jbwtp,

 

That got rid of the error, but it doesn't appear to have done anything in my query.  Player 296 still has the wrong fangraphs ID.  It also did a weird thing to the query language overall after I ran it. 

 

The last statement in the query before I put your language in was...

in # "added index"

After I ran your language it changed to...

in
#"Added Index"
in
#"Pitcher Contracts with IDs

 

jbwtp's avatar
jbwtp
Memorable Member
3 years ago

Hi coreych, 

 

This is a bit strange that the Index is text rather than number, but I guess this is Ok if PQ does not throw any error.

Do you want to use this code and check what it returns to Player IDs.IDFANGRAPHS and may be figre out how to set the condition to actually make the replacement (x should be the current Player IDs.IDFANGRAPHS value, y should be Index and z should be null)?

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

 

If it returns all variables as expected, do you wan tto try to make the Index to be of type number rather than text and change the filter accrodingly?

 

Cheers,

John