Forum Discussion

jhenscheid's avatar
jhenscheid
Frequent Visitor
9 years ago
Solved

split/group multiple columns based on primary column

I am trying to split out the ChargeType, BasisType, Rate and BillableTotal columns in to their own column so that each LoadID is only consuming one row.   For example, LoadID 52315053 would be on o...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    jhenscheid

     

    Hi, Please try this in Query Editor:

     

    Steps in Query Editor

    Regards

     

    Victor

    Lima - Peru

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

jhenscheid

 

Hi, Please try this in Query Editor:

 

Steps in Query Editor

Regards

 

Victor

Lima - Peru

jhenscheid's avatar
jhenscheid
Frequent Visitor
9 years ago

Thank you for your help.  This worked grreat.  I actually had another table with a similar layout and used the steps for that table as well.

 

thanks again!