Field not found

[debmsarkar123]

I have a cross table-

Data:
CrossTable(Week, Forecast, 5)
LOAD [Art. - Nr.
Dose],
[Deko-Nr.],
[Nach-
folger],

FROM
[Z:\Docs\test_data.xlsx]
(ooxml, embedded labels, header is 3 lines, table is forecast);

Now when I do -

concatenate (Data)
LOAD *,

LOAD replace(ltrim(rtrim(purgechar([Deko-Nr.],chr(160)))),'0000000000','') as [ABC],



Resident Data $(vWhere);

I get this error-

Error: Field not found - <Deko-Nr.>

Even though when I load the Data table I can see data in Deko-Nr. 

[saniyask]

Yes, Because after cross table  - Deko-Nr. does not exist as a separate field. It is an attribute under the attribute field Week. You can do this conversion in the initial step itself when you are transforming the table into cross table.

[debmsarkar123]

How do I solve this ? I didn't understand your solution.  Could you please elaborate on that ?