Bulkreplace value for same table from multiple tables

[bishnu]

Hello

I am trying use bulk replace function in powerbi to replace 6 column data (from Table A) using data from Table B and table C 

I have asked similar doubt before and tried to modify the query provided

https://community.powerbi.com/t5/Power-Query/Cross-verification-between-two-tables-and-if-condition-....

But it didnt help

i used the following power query

Step 5 Custom = fBulkReplace(#"Changed Type",Table B,{"Doc 1","Doc 2"})

Step 5 works perfectly

but when i apply the addtional query i.e step 6, it takes me back to table A without bulk replace

Step 6 Custom1= fBulkReplace(#"Custom",Table C,{"Phot 1","Phot 2","Phot 3"})

Table B and Table C comes from 2 diffrent data sources.

Thanks in advance

[artemus · Accepted solution]

It looks like this function replaces text with text (including substrings). It won't work with true/false. Also it in general works completly differently than you want it too.