Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

MindaugasBacius
Valued Contributor II

No table is created

I have a script.

Unfortunately, I cannot figure out what is wrong because map_Tour is an empty table. Actually there is no table after reload.

tmp:

LOAD SY103_WOCHENTAG,

     SY103_TOUR_NR

FROM

Source

(qvd);

tmp2:

CrossTable(Day, Tour)

LOAD ID,

     [1],

     [2],

     [3],

     [4],

     [5],

     [6],

     [7]

FROM

Source

(ooxml, embedded labels, table is Points);

Concatenate (tmp)

load distinct ID & '|' & Day as SY103_WOCHENTAG

  ,Tour as SY103_TOUR_NR

Resident tmp2

where not(Exists(SY103_WOCHENTAG, ID & '|' & Day))

;

DROP Table tmp2;

map_Tour:

Load *

Resident tmp;

DROP Table tmp;

When I add any new field in map_Tour I get the table:

map_Tour:

Load *

     ,1

Resident tmp;

But I would like to understand the reasons why the script without any additional field in the map_Tour do not work.

Thank you!

1 Solution

Accepted Solutions
Highlighted
jerrysvensson
Valued Contributor II

Re: No table is created

Try

map_Tour: 

noconcatenate Load * 

Resident tmp;

5 Replies
Highlighted
jerrysvensson
Valued Contributor II

Re: No table is created

Try

map_Tour: 

noconcatenate Load * 

Resident tmp;

Re: No table is created

Hi,

Use noconcatenate

because table field in tmp and map_tour contain same field Name there for qlikview automatically concatenate the table.

Regards

Regards,
Prashant Sangle

Re: No table is created

  1. map_Tour: 
  2. Load
  3. Resident tmp; 
  4.  
  5. DROP Table tmp;

  6. The above table has same fieldname and same column numbers as tmp table so qlikview auto concatenate them.. now when you drop tmp table.. everything getting dropped becuase there is not map_tour table...

  7. Use
  8. NoConcatenate
  9. map_Tour: 
  10. Load
  11. Resident tmp; 
  12.  
  13. DROP Table tmp;
MindaugasBacius
Valued Contributor II

Re: No table is created

Jerry Svensson

It works fine!

Could you explain it briefly?

When I am not using noconcatenate statement all the data is concatenated and it appears as a part of tmp table?

When dropping tmp I am just removing all the data, am I right?

jerrysvensson
Valued Contributor II

Re: No table is created

Yes, QlikView will auto concatenate tables if they have similar or identical fields.

map_tour will be concatenated to the tmp table and therefore will not be created as a table itself.