Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
jerrysvensson
Valued Contributor II

Re: No table is created

Try

map_Tour: 

noconcatenate Load * 

Resident tmp;

5 Replies
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

Great dreamer's dreams never fulfilled, they are always transcended.
MVP
MVP

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.

Community Browser