Forum Discussion

sersanch's avatar
sersanch
New Member
3 years ago
Solved

Rank column directly in table creation script?

Hi guys,   I'm trying to get a rank column in the same script I create a new table as follows, but reference inside filter to tmp1 is not accepted (tmp1 table not found). If I just return the table...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi sersanch 

    You cannot use a variable name as a table reference. You can try by referring the column name only

    aidsByDateCarts =
    VAR tmp1 =
    FILTER (
    SUMMARIZE (
    train,
    train[events.type],
    train[timest].[Date],
    train[events.aid],
    "numEvents", COUNT ( train[events.aid] )
    ),
    train[events.type] = "carts"
    )
    VAR tmp2 =
    ADDCOLUMNS (
    tmp1,
    "rank", RANKX ( FILTER ( tmp1, [Date] = EARLIER ( [Date] ) ), [numEvents] )
    )
    RETURN
    tmp2

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi sersanch 

You cannot use a variable name as a table reference. You can try by referring the column name only

aidsByDateCarts =
VAR tmp1 =
FILTER (
SUMMARIZE (
train,
train[events.type],
train[timest].[Date],
train[events.aid],
"numEvents", COUNT ( train[events.aid] )
),
train[events.type] = "carts"
)
VAR tmp2 =
ADDCOLUMNS (
tmp1,
"rank", RANKX ( FILTER ( tmp1, [Date] = EARLIER ( [Date] ) ), [numEvents] )
)
RETURN
tmp2