I'm working with survey Data . see attached QVF. My data has first 3 columns . For my analysis I need to create two metrics to find count( highest rating keys) and count( lowest rating keys).
I am trying to create a new column based out of value from 3rd column which I can use in my metric. for that I need to take numeric part from 3rd column(response value) starting with numbers. that from 0-10.
I tried using both Purgechar() and keepchar() . but doesn't seem to get desired result.
Prugechar() - NOTHING CHANGES
KeepChar()- seems to remove characters leaving behind numbers . where as I should be able to see numbers in newly created columns where values are between 0-10 .
e.g row-1 & row-4 should be blank & not 4 . row8 and row 12 should be blank too. so dees line 14 & 17
first 3 rows from your screen shot are not ratings that are options for question. so when you do subfield <10 it displays 3 , 4,5 in new column for respective rows .
They are showing up because I added extra data for them to show up. I still stand by that my expression from my previous post will work. If it isn't working, can you post another QVF files with those values to show me? Because the new values you mentioned aren't in your example, and I probably added them differently than how they would look in your data.
How do you know which values you want to use the numbers from and which ones you don't? In order to code for it, I need to understand how to differentiate the ones that you want from the ones that should be NULL.
