Data load error

[Akshay_SH]

I am getting the following error while loading the data with the following script.
Can anyone please help

  

[edwin]

what does the table raw look like?  or at least the script that created raw?

[vikramv]

 I think the field aliasing that you did in tmp_raw table, should be done 1 step before.

Meaning, There should be a prior resident load in which you do your field aliasing first.

Then you can apply CrossTable on top of that new table as resident load.

Thanks

Vikky

[Ksrinivasan]

hi,

do this

P1 as Jan_2020

ksrinivasan.

[Ksrinivasan]

hi,

cross_doubt:
CrossTable (date, qty,4)
LOAD
ID,
Weight,
PlannNo,
Price,
P1 as Jan_2020,
P2 as Feb_2020,
P3 as Mar_2020,
P4 as Apr_2020

from file

temp:
Load
ID,
Replace(date,'_','/') as FFFF,
qty
Resident [cross_doubt];
drop Table cross_doubt;

result

ksrinivasan