10-07-2014 03:28 PM
I am trying to do some Regression analysis and the table that I am using as my input has some data gaps.
Thesis what I mean by it. I used "Spit Column" function in the EG in order to create a Cross tab Table from a flat table. However as is the case in some cases there is some missing data here and there.
So my question is how do I make empty points (.) become 0 so that I can do my regression analysis.
For general reference I have showed how data looks after transposing the input table.
|Product 3||Product 4|
P.S. There are about 70 Products so i tough about writing a new query and doing computations on each of the new columns but that just seems crazy.
Thanks for any help you can offer.
10-07-2014 04:00 PM
What kind of analysis were you planning?
It may be that your data structure would work better as: Company ProductDescription Value. Then you wouldn't have any "gaps".
10-07-2014 05:51 PM
Put it in as a code node (File | New | Program), link the output dataset from your "Split Columns" to it, and replace the dataset name "have" with the name of the dataset created by your split columns.