topic Merge Column in Dataflow

Merge Column

Mohammed- — Sun, 01 Sep 2024 23:55:40 GMT

Please need help for merge 2 column in the same table to create a ne culomn

the new column should be include the following

2004-01

2004-02

2004-03

2004- 04

Thanks

Mohammed

Anonymous — Mon, 02 Sep 2024 01:16:55 GMT

I create a table as you mentioned in Data Factory.

Then I think you can create a custom column.

Custom = Text.From([Year]) & "-" & Text.PadStart(Text.From([Mon]), 2, "0")

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Mohammed- — Mon, 02 Sep 2024 16:00:13 GMT

Dir Sir,

Thanks for your Replay

I used your Formula

Table.AddColumn(#"Sorted rows", "Custom", each Text.From([Year]) & "-" & Text.PadStart(Text.From([Mon]), 2, "0"))

it is working fine with me

This is the result after some trasnformation

Thanks Again