Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am stuck with this problem.
Each row has a value, Min(Value), Gap and Number.
Value is an input.
Min(Value) = Minimum among all values for each data point in Column 1.
For eg. For A1 in the table below, there are 3 values. Minimum of these 3 values is needed in Min(Value)
Gap = Value - Min(Value) for each row.
Each data point is to be numbered in ascending order of Value.
Column 1 | Column 2 | Value | Min(Value) | Gap | Number |
A1 | B1 | 300 | 100 | 200 | 3 |
A1 | B2 | 100 | 100 | 0 | 1 |
A1 | B3 | 200 | 100 | 100 | 2 |
A2 | C2 | 50 | 50 | 0 | 1 |
A2 | C1 | 100 | 50 | 50 | 2 |
I could do till Gap. I used Group by to get Min(TDC) but I am unable to assign "Number"
Any help is really appreciated.
Regards
Raghav
I thought that you want to create the number column.
Change the name anyway you like:
tData:
Load
*,
if (peek('Column1')<>Column1, 1, peek('NewName')+1) as NewName
resident Data
order by Column1, Gap
;
See attached qvw.
Thanks for the immediate input Gysbert.
Is there anyway to do this through Script?
I need to use "Number" column as a list box.
Regards
Raghav
Let's say that your are in table callde Data.
Then you could use :
Noconcatenate
tData:
Load
*,
if (peek('Column1')<>Column1, 1, peek('Number')+1) as Number
resident Data
order by Column1, Gap
;
Thanks nannyogg
But if 'Number' is already defined once in a previous table, would it be possible to add use the same name again?
I tried this and got an error "Field names must be unique within the table"
Any way around for this problem?
Regards
Raghav
I thought that you want to create the number column.
Change the name anyway you like:
tData:
Load
*,
if (peek('Column1')<>Column1, 1, peek('NewName')+1) as NewName
resident Data
order by Column1, Gap
;
Thanks Nannyogg.
That was the error I had been doing.
I was defining 'Number' earlier in the table.
Also I tried using Previous(Number). I am not very clear on the difference between Peek and Previous functions.
Regards
Raghav