Creating new field in script

jessica_webb — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Creating new field in script

MK_QSL — Fri, 13 Jan 2017 14:24:38 GMT

Try

JOIN (Data)

LOAD * Resident Data;

Final:

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

Resident Data;

Drop Table Data;

Re: Creating new field in script

jessica_webb — Fri, 13 Jan 2017 14:30:21 GMT

Perfect!

Thank you very much

topic Re: Creating new field in script in QlikView

Creating new field in script

Re: Creating new field in script

Re: Creating new field in script