Forum Discussion

charles_o's avatar
charles_o
Helper I
8 years ago
Solved

Split value in column with multiple dates

 Hi-   New user and of course lots of questions!   I currently have data that looks like this-     The fee is earned 50% on date.1 and 50% on date.2.   The data has to be able to graph...
Need Help
  • SteveCampbell's avatar
    SteveCampbell
    8 years ago

    Open advanced editor. With your Query, go to the " Add Column" 1 tab and click "Custom Column" 2 .

     

    Change the name to New Fee 3.

    Enter The following Formula 4:

     

    =[Fee]/2

     

     

    Now you can delete the original column Fee.

     

    Highlight both date colunms. On the Transform tab, click Unpivot Columns.

     

     

    It will give you two new columns, Attribute and Value. You can delete Attribute*, rename Value as Date.1/Date.2, and rename New Fee as Fee.

     

    *Also, if you wanted to know if it was date 1 or date 2 then do not delete attribute!

     

SteveCampbell's avatar
SteveCampbell
Memorable Member
8 years ago

Open advanced editor. With your Query, go to the " Add Column" 1 tab and click "Custom Column" 2 .

 

Change the name to New Fee 3.

Enter The following Formula 4:

 

=[Fee]/2

 

 

Now you can delete the original column Fee.

 

Highlight both date colunms. On the Transform tab, click Unpivot Columns.

 

 

It will give you two new columns, Attribute and Value. You can delete Attribute*, rename Value as Date.1/Date.2, and rename New Fee as Fee.

 

*Also, if you wanted to know if it was date 1 or date 2 then do not delete attribute!

 

charles_o's avatar
charles_o
Helper I
8 years ago

Thanks! Glad to see an active community here.