field not found in qlikview

[capriconuser]

i have data in excel like this 

EmpNo   Name   Size    31-12-2020    12-01-2021
1      abc     50        45              23            
2     def      50       23              12
3     xyz      50       34              67

I try to load data in qlikview like this using cross table 

EmpNo  Name   Size  Current_size  Date
1      abc      50       45      31-12-2020
1      abc      50       23      12-01-2021
2      def       50      23       31-12-2020
2     def       50       12        12-01-2021
3     xyz         50     34        31-12-2020
3     xyz         50    67         12-01-2021

I try this script

Email:
CrossTable(Email_Date, Current_size, 3)
LOAD EMP# as EmployeeID , 
     User as FullName, 
     [Total Size], 
     Current_size,
    Replace(left(Current_size,index(Current_size,' ')),chr(8206),'') as  Current_size,
   Year(Email_date) as Email_Year,
     Month(Email_date) as Email_Month,
     [31-12-2020], 
     [31-01-2021]
FROM
[data\Ma.xlsx]
(ooxml, embedded labels, table is Sheet2);
Load  
    EmployeeID
   Class(Current_size, 10, 'and') as Size

Resident Email;

Exit SCRIPT;

but this shows me an error that Current_size field is not found .

any help please

[QFabian]

Hi @capriconuser , you cannot use that field beacause isnt exists yet, just after the load is finished, you can use it,  in another load maybe with resiedent, please check this example :

Email:
CrossTable(Email_Date, Current_size, 3)
Load

EmpNo,

Name, Size

31-12-2020

12-01-2021

FROM [data\Ma.xlsx] (ooxml, embedded labels, table is Sheet2);

Data2:

*,

Replace(left(Current_size,index(Current_size,' ')),chr(8206),'') as Current_size,
Year(Email_date) as Email_Year,
Month(Email_date) as Email_Month,

Load

Resident email;

drop table email;

[capriconuser]

@QFabian 

from email month and email year.. i did not get month and year in table box .. this shows '-' in table box