Forum Discussion

FrancoisRiek's avatar
FrancoisRiek
Regular Visitor
3 years ago
Solved

Column Splitting

My column has account references for instance (1000/001; 1001/001) and dates for instance (23/03/2022, 01/04/2022).  How do I split it in two columns, one for account references and the other for date?  Thx

6 Replies

    • FrancoisRiek's avatar
      FrancoisRiek
      Regular Visitor

      Hi Manoj

       

      See below as an example, I need to split the column into two columns, one for Account Ref and one for date,

      1000/001

      23/03/2022

      24/03/2002

      1001/001

      02/04/2022

      Thx

       

      • Manoj_Nair's avatar
        Manoj_Nair
        Solution Supplier

        FrancoisRiek 

        If the below meets your requirement, I will post the PBIX file which has the transformation steps