Data append one-to-many
Posted: Fri Sep 11, 2015 6:31 am
Dear Eviews masters :)
I need your help in such a case (see attachment, Eviews 8.1):
- I want my final dataset to be structured by id variable called conversionid. In the same Eviews page I have userid which indicates which user did a conversion - in the example I left one case where there is one user who made two conversions.
- In the other Eviews page, I have information what a user was doing - in the example I left just time of event (eventdate variable).
- And now the problem - how to append the eventdate to the final dataset such that eventdate is repeated for each conversion of the same user? I did it manually to explain you what I mean precisely (page "should_look_like").
So when I just append one page to the other, I will have two rows of conversion and userid values, and 3 rows of appended eventdate. But I am interested in conversion paths, not user paths, so I need 3 rows to append to each conversion.
thanks in advance :)
adrian
I need your help in such a case (see attachment, Eviews 8.1):
- I want my final dataset to be structured by id variable called conversionid. In the same Eviews page I have userid which indicates which user did a conversion - in the example I left one case where there is one user who made two conversions.
- In the other Eviews page, I have information what a user was doing - in the example I left just time of event (eventdate variable).
- And now the problem - how to append the eventdate to the final dataset such that eventdate is repeated for each conversion of the same user? I did it manually to explain you what I mean precisely (page "should_look_like").
So when I just append one page to the other, I will have two rows of conversion and userid values, and 3 rows of appended eventdate. But I am interested in conversion paths, not user paths, so I need 3 rows to append to each conversion.
thanks in advance :)
adrian