Null record logged in MSSQL when using parser payload value to logged

parser-
msg.payload = ["swapmicro","swapmicro@gmail.com","swap","zzz@321",55.66];
return msg;

DECLARE @data VARCHAR(MAX)
DECLARE @Name VARCHAR(50)
DECLARE @Email VARCHAR(50)
DECLARE @usName VARCHAR(50)
DECLARE @PWD VARCHAR(50)
DECLARE @NUB FLOAT
SET @Name = '{{{msg.payload[0]}}}';
SET @Email = '{{{msg.payload[1]}}}';
SET @usName = '{{{msg.payload[2]}}}';
SET @PWD = '{{{msg.payload[3]}}}';
SET @NUB = '{{{msg.payload[4]}}}';
INSERT INTO dbo.Test
( name, email, usName, pwd,nub )
VALUES ( @Name,
@Email,
@usName,
@PWD,
''
)
then null record logged in table .

Best guess - data is null because you dont specify the column or a value for the data field in your INSERT statement.