Load script- how to edit a record

[emilyrabbit]

HI all,

because the content lack , and I can't edit the resource.  So, I want to edit in the loading scrip, fulfill the [Sales Sector Region1] like below.

I write the below script and it goes wrong. Pls

RENAME TABLE DIM_SALES_SECTOR_FLUID_CONNECTORS_HAN TO TEMP3;
DIM_SALES_SECTOR_FLUID_CONNECTORS_HAN:
NoConcatenate
LOAD *,
if([Sales Sector Code]='2CN100','2CN100',[Sales Sector Region1])as [Sales Sector Region1],
if([Sales Sector Code]='2CN100','2CN100',[Sales Sector Region2])as [Sales Sector Region2]
Resident TEMP3;
Drop Table TEMP3;

[marksouzacosta]

Hi @emilyrabbit ,

Table name should not matter so you can try this:

RENAME FIELD [Sales Sector Region1] TO [REMOVE Sales Sector Region1];
RENAME FIELD [Sales Sector Region2] TO [REMOVE Sales Sector Region2];

DIM_SALES_SECTOR_FLUID_CONNECTORS_HAN_EXT:
LOAD
	*,
	if([Sales Sector Code]='2CN100','2CN100',[REMOVE Sales Sector Region1])as [Sales Sector Region1],
	if([Sales Sector Code]='2CN100','2CN100',[REMOVE Sales Sector Region2])as [Sales Sector Region2]
Resident 
	DIM_SALES_SECTOR_FLUID_CONNECTORS_HAN
;

DROP FIELDS
    [REMOVE Sales Sector Region1],
    [REMOVE Sales Sector Region2]
FROM  
    DIM_SALES_SECTOR_FLUID_CONNECTORS_HAN_EXT
;

DROP TABLE DIM_SALES_SECTOR_FLUID_CONNECTORS_HAN;