Help me to fix null value in Straight table

[karan_kn]

Please help me to fix null value. Attached QVW and excel for your reference.

[sunny_talwar · Accepted solution]

May be using this

=If(ID = Above(TOTAL ID), Null(), Name)

[vishsaggi]

may be another way like

Table:
LOAD *
WHERE DupId = 1;
LOAD ID,
IF(ID = Previous(ID), 0, 1) AS DupId,
Name,
Country
FROM
TestNull.xlsx
(ooxml, embedded labels, table is Sheet1);