Creating new field in script

[jessica_webb]

Hello,

Can't understand why this isn't working...

I have several sources in my script, that I am loading to create on main table called 'Data'.

In one part of the script, I load a field called 'Target'.

Later in the script, I LEFT JOIN a new table to 'Data', which includes a field called 'Type'.

I would now like to create a field called 'Type-Target' which is a combo of the two.

I have tried:

JOIN (Data)

LOAD*,

Type & Target as [Type-Target]

Resident Data;

This kind of works, but I get repeating rows. So for example, I will have two identical rows, one that has 'Type-Target' and one where the cell is null.

What am I doing wrong?

Thanks,

Jess

[MK_QSL · Accepted solution]

Try

JOIN (Data)

LOAD * Resident Data;

Final:

Load *, Type & Target as [Type-Target]

Resident Data;

Drop Table Data;

[jessica_webb]

Perfect!

Thank you very much