topic Re: No data after resident in QlikView

No data after resident

Yevhenii_Senko — Wed, 15 Feb 2017 13:38:26 GMT

Hi,

Please look at the script below.

In this case I will not get any data.

Can't understand logic.

I use resident and it have to bring all data from Table1 to TableTotal.

Table1:

Load * INLINE [

Name, Data

First, 1

Second, 2

Third, 3

];

LEFT JOIN(Table1)

Table2:

LOAD * INLINE [

Value

1];

TableTotal:

LOAD *

Resident Table1;

Drop Table Table1;

Re: No data after resident

sunny_talwar — Wed, 15 Feb 2017 13:39:54 GMT

You need to add NoConcatenate necause Table1 and TableTotal have the same field names and will auto-concatenate. To avoid auto-concatenate we add NoConcateante.

Table1:

Load * INLINE [

Name, Data

First, 1

Second, 2

Third, 3

];

LEFT JOIN(Table1)

Table2:

LOAD * INLINE [

Value

1];

TableTotal:

NoConcatenate

LOAD *

Resident Table1;

Drop Table Table1;

Re: No data after resident

Yevhenii_Senko — Wed, 15 Feb 2017 13:50:23 GMT

Thanx Sunny.

You are right.

But one more question plese.

I need also do

FOR EACH vFile in FileList

with the same code above.

All files are the same with different data.

As result I need one table with all data from files.

If I use Noconcatenate I will receive a lot of tables.

Do you know how to solve it?

Re: No data after resident

sunny_talwar — Wed, 15 Feb 2017 13:53:49 GMT

Add a flag when you create your new table (for example 1 as Dummy). This will help you avoid the initial auto concatenate. Later you can drop this Dummy field

Table1:

Load * INLINE [

Name, Data

First, 1

Second, 2

Third, 3

];

LEFT JOIN(Table1)

Table2:

LOAD * INLINE [

Value

1];

TableTotal:

LOAD *,

1 as Dummy

Resident Table1;

Drop Table Table1;

DROP Field Dummy;

Re: No data after resident

Yevhenii_Senko — Wed, 15 Feb 2017 14:17:47 GMT

This way create few tables.

As I see after first cycle TableTotal will have different structure to Table1

Try to use

Table1:

Load * INLINE [

Name, Data

First, 1

Second, 2

Third, 3

];

LEFT JOIN(Table1)

Table2:

LOAD * INLINE [

Value

1];

Concatenate

TableTotal:

LOAD *,

1 as Dummy

Resident Table1;

Drop Table Table1;

DROP Field Dummy;

Get error "Field not found. Did not find field Dummy from the DROP FIELD statement"

Re: No data after resident

Yevhenii_Senko — Wed, 15 Feb 2017 14:54:50 GMT

You wrote true.

Only need add Drop field after "next"

It means when cycle is finished then drop temporary field.

Thanx a lot!