RowNo Error? Duplicate values in Concatenate Load after delete rows

[#1]

RowNo() inserts duplicates values after I've delete rows.

This is a very simple example:

// FIRST LOAD

[test]:

load

  RowNo() as MyRowNo

  ,value

Inline [

  value

  'x'

  'y'

  'z'

];

// REMOVE ROWS

inner keep([test])

load

  MyRowNo

resident

  [test]

where

  MyRowNo=2

;

// CONCATENATE ROWS

[test]:

Concatenate([test])

load

  RowNo() as MyRowNo

  ,value

Inline [

  value

  'a'

  'b'

  'c'

];

And the result is

MyRowNo	value
2	a
2	y
3	b
4	c

Why I've duplicate values? How to resolve? This is a simple example but my code is very complex !!!

[sunny_talwar]

What do you expected to see? This:

Try RecNo() instead of RowNo()

// FIRST LOAD

[test]:

load

  RowNo() as MyRowNo

  ,value

Inline [

  value

  'x'

  'y'

  'z'

];

// REMOVE ROWS

inner keep([test])

load

  MyRowNo

resident

  [test]

where

  MyRowNo=2;

// CONCATENATE ROWS

[test]:

Concatenate([test])

load

  RecNo() as MyRowNo

  ,value

Inline [

  value

  'a'

  'b'

  'c'

];

[aarkay29]

or Use Join instead of concatenate

// FIRST LOAD

[test]:

load

  RowNo() as MyRowNo

  ,value

Inline [

  value

  'x'

  'y'

  'z'

];

// REMOVE ROWS

inner keep([test])

load

  MyRowNo

resident

  [test]

where

  MyRowNo=2

;

// CONCATENATE ROWS

[test]:

Join([test])

load

  RowNo() as MyRowNo

  ,value

Inline [

  value

  'a'

  'b'

  'c'

];

And the result is

MyRowNo	value
2	a
2	y
3	b
4	c

[maxgro]

or maybe

// FIRST LOAD

[test]:

load

  RowNo() as MyRowNo

  ,value

Inline [

  value

  'x'

  'y'

  'z'

  'w'

  'j'

]

;

// REMOVE ROWS

inner keep([test])

load

  MyRowNo

resident

  [test]

where

  MyRowNo=2 or MyRowNo=3 

;

let v = NoOfRows('test');

// CONCATENATE ROWS

[test]:

Concatenate([test])

load

  $(v) + RowNo() as MyRowNo

  ,value

Inline [

  value

  'a'

  'b'

  'c'

  'y'

]

;

[#5]

RecNo is not right.

I want an unique value for MyRowNo field

[#6]

Join is not right.

I want an unique value for MyRowNo field and all values (I have to use Concatenate)

Somthig like this:

[#7]

This solution works fine (thank's a lot!), But why RowNo() function works badly?

[aarkay29]

Modifying Massimo's script slightly for RecNo() to work

// FIRST LOAD

[test]:

load

  RowNo() as MyRowNo

  ,value

Inline [

  value

  'x'

  'y'

  'z'

]

;

let v = NoOfRows('test');

// REMOVE ROWS

inner keep([test])

load

  MyRowNo

resident

  [test]

where

  MyRowNo=2

;

// CONCATENATE ROWS

//[test]:

Concatenate([test])

load

  $(v)+RecNo() as MyRowNo

  ,value

Inline [

  value

  'a'

  'b'

  'c'

]

;

[#9]

With your idea

let v = NoOfRows('test');

// CONCATENATE ROWS

[test]:

Concatenate([test])

load

  $(v) + RowNo() as MyRowNo

  ,value

Inline [

....

It's also possible use RecNo() function, adding 1:

let v = NoOfRows('test');

// CONCATENATE ROWS

[test]:

Concatenate([test])

load

  $(v) + RecNo() +1 as MyRowNo

  ,value

Inline [

....

[#10]

RecNo() function it's possible but adding 1:

$(v) + RecNo() +1 as MyRowNo