Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Can you help me please? Why is the value circled in red equal "2"? It should be "1". How I can do it?
[Table_Temp]:
LOAD ID, STATUS, STATUS_NEXT, DATE_EDIT
FROM
[C:\Users\User\Desktop\test2809.xlsx]
(ooxml, embedded labels);
[Table1]:
NoConcatenate
LOAD ID, STATUS, DATE_EDIT as Date_1, AutoNumber(RowNo(), ID) as Numer_1
Resident Table_Temp
Where STATUS = 'Z047';
[Table2]:
NoConcatenate
LOAD ID, STATUS_NEXT, DATE_EDIT as Date_2, AutoNumber(RowNo(), ID) as Numer_2
Resident Table_Temp
Where STATUS_NEXT = 'Z047';
DROP TABLE Table_Temp;
Try using Peek() instead of AutoNumber() to build this
[Table_Temp]:
LOAD ID,
STATUS,
STATUS_NEXT,
DATE_EDIT
FROM test2809.xlsx
(ooxml, embedded labels);
[Table1]:
NoConcatenate
LOAD ID,
STATUS,
DATE_EDIT as Date_1,
AutoNumber(RowNo(), ID) as Numer_1,
If(ID = Peek('ID'), RangeSum(Peek('Numer_1_1'), 1), 1) as Numer_1_1
Resident Table_Temp
Where STATUS = 'Z047'
Order By ID;
[Table2]:
NoConcatenate
LOAD ID,
STATUS_NEXT,
DATE_EDIT as Date_2,
AutoNumber(RowNo(), ID) as Numer_2,
If(ID = Peek('ID'), RangeSum(Peek('Numer_2_2'), 1), 1) as Numer_2_2
Resident Table_Temp
Where STATUS_NEXT = 'Z047'
Order By ID;
DROP TABLE Table_Temp;
Try using Peek() instead of AutoNumber() to build this
[Table_Temp]:
LOAD ID,
STATUS,
STATUS_NEXT,
DATE_EDIT
FROM test2809.xlsx
(ooxml, embedded labels);
[Table1]:
NoConcatenate
LOAD ID,
STATUS,
DATE_EDIT as Date_1,
AutoNumber(RowNo(), ID) as Numer_1,
If(ID = Peek('ID'), RangeSum(Peek('Numer_1_1'), 1), 1) as Numer_1_1
Resident Table_Temp
Where STATUS = 'Z047'
Order By ID;
[Table2]:
NoConcatenate
LOAD ID,
STATUS_NEXT,
DATE_EDIT as Date_2,
AutoNumber(RowNo(), ID) as Numer_2,
If(ID = Peek('ID'), RangeSum(Peek('Numer_2_2'), 1), 1) as Numer_2_2
Resident Table_Temp
Where STATUS_NEXT = 'Z047'
Order By ID;
DROP TABLE Table_Temp;
Sunny, great thanks for your help!