I have a very basic question for QV experts. I'm pulling lots of data (millions of rows) and one of my current fields pulls a column of numeric value (3 digits) byte size to be exact - field name 'Bytes'.
Currently I'm seeing about 8 different byte size transactions. I would like to classify everything under 200 bytes a given description (small) and everything 200 bytes and above (large).
Since I am dealing with a lot of data, I am not sure which is the best method from a processing point of view. What would be the best method to do so?
Option 1: Edit Script - can someone please help me how I can write a line that would do this for me?
Option 2: Create a new dimension reference
My only concern with creating a new dimension is that I see maybe 8 different byte sizes so far. If i start to see more, will I have to keep adding to my dimension look-up that I created? Is there a way to capture every number that is added to Bytes? I would prefer not to reference every single number between 1 and 200 as small and then reference 200 + as large
this can be done in your load statement itself. create another field in your load with something like:
if(Bytes<200,'Small','Large') as Size
now your Size field with have values "Small" or "Large" for each of your "Bytes". if you have more buckets, just modify the condition in the if statement.
this can be done in your load statement itself. create another field in your load with something like:
if(Bytes<200,'Small','Large') as Size
now your Size field with have values "Small" or "Large" for each of your "Bytes". if you have more buckets, just modify the condition in the if statement.
