Hi,
This video talks talks about how to do calculations inside Report module of AETL
1. We learn basic multiplication and divide
2. We learn to convert string to intetger
VIDEO HERE
Blooper Reel over here
1. Preview button goes missing
2. I think a 'reset' button in AETL settings which deletes registry setting will be helpful
Material
My JSON
{ "mobile": "9563214545", "calculate": "356", "name": "tanvi Test", "position": "HR", "Annual CTC": "5200000", "join date": "2024-07-29", "Address": "herre there only", "joining Company": "Krishna Beads Industries" }
SQL
DECLARE @json NVARCHAR(MAX);
SELECT @json = text_field_02 FROM event_log WHERE id ='874cafd9-2f44-4f14-98b7-4520bc03eef5';
SELECT * FROM OpenJson(@json)
WITH (
"name" VARCHAR(100) '$."name"',
"calculate" VARCHAR(100) '$."calculate"',
"location" VARCHAR(100) '$."Address"',
"annual_ctc" INT '$."Annual CTC"',
"company_header" VARCHAR(100) '$."joining Company"',
"company_footer" VARCHAR(100) null
);
