How to swap some values between two columns in power query using either GUI elements or M code?

[Aasozab]

How to swap some values between two columns in power query using either GUI elements or M code?

[AlienSx]

    Table.ReplaceValue(
        your_table,
        each [DOJ],
        each [Designation],
        (v, o, n) => if Value.Is(n, Text.Type) then v else if Value.Is(v, Text.Type) then n else o, 
        {"DOJ", "Designation"}
    )

[dufoq3]

Hi, I dind´t provide the code with sample data, but you can create it either in power query vie Enger Data button or in excel and then import to power query.

The purpose was to show sou the way how to achieve expected result. You can use codes above by adding them separately as custom column. Just replace [Column1] with [DOJ] and [Column2] with [Designation]. Don't forget to set column name for first code: "Extracted Date".

[Aasozab]

Thank you for your reply. Would you plz tell me how can i download sample data you provided in the solution?

[dufoq3 · Accepted solution]

Hi @Aasozab, I recommend you to create new pair of columns with extracted values:

[Extracted Date]

if (try Date.From([Column1]) otherwise false) is date then [Column1] else [Column2]

[Extracted Text]

if [Column1] = [Extracted Date] then [Column2] else [Column1]

[Aasozab]

Hi @dufoq3 . I got these errors when followed your steps:

Please tell me:

1. whether or not I followed your steps correctly?

2. Why getting this error?

TIA

[dufoq3]

You have to add them into-your query as a custom column.

[Aasozab]

I have done so.

Check thse steps and plz tell where I have made a mistake. and why i am getting error in last step and plz also tell what would be next steps?

123456

[dufoq3]

You addec just "" into Custom Column. You have to add my code there 🙂 Read carefuly my guidelines again please.

[Aasozab]

yes it works now. Thank you so much. I was confused by Note at bottom i.e. Note: Check this link to learn how to use my query. and was following these steps:

[dufoq3]

You're welcome. I have notes as signature, because usualy I use sample data.