ApplyMap after crosstable

[jessica_webb]

Hello,

I have a problem which I feel should be straightforward to solve. But I can't do it...

Basically, I have a table called Data.

I then load a temp table as a crosstable, called 'tempData'.

I then left join my tables:

LEFT JOIN (Data) LOAD * Resident tempData;

Drop TABLE tempData;

Now, I want to applymap to one of the fields that was in tempData, but is now in Data.

How do I do this?

Many thanks,
Jess

[jessica_webb]

Perfect! Thanks Staffan!

Knew it couldn't be as tricky as I was finding it!

Really appreciate your help.

[jessica_webb]

Agreed actually - sorry Staffan

Thanks Sunny, my script is looking even neater!

Huge thanks to you both.

Jess

[stabben23]

Resident load on Fact table should be avoid if not necessary.

[sunny_talwar]

Agreed