topic Re: Append New Data in QlikView

Append New Data

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

Hi Community,

I have 2 different tables, same structure in tables.

I need concatenate these tables.

One table i need to reload every day, and other table i want to reload month starting dates. (like 1, 2 dates)

Example:

// Here This table reloads every day

Load CatID,

CatName,

Desc,

UnitPrice,

UnitCost

From Category;

Concatenate

// This table i want to reload every month only first 2 days

Load CatID,

CatName,

Desc,

UnitPrice,

UnitCost

From Category_NewDate;

We are reloading manually, Every month first 2 days reloading after that we are commenting second table code.

Can we do Automatically ????

Thanks in Advance...

Re: Append New Data

sunny_talwar — Thu, 12 May 2016 22:46:00 GMT

Try this may be:

Example:

Load CatID,

CatName,

Desc,

UnitPrice,

UnitCost

From Category;

If Day(Today()) = 1 or Day(Today()) = 2 then

Concatenate (Example)

Load CatID,

CatName,

Desc,

UnitPrice,

UnitCost

From Category_NewDate;

ENDIF;

Re: Append New Data

swuehl — Thu, 12 May 2016 23:02:07 GMT

I would explicitely set the timer mode to use the current date:

Example:

Load CatID,

CatName,

Desc,

UnitPrice,

UnitCost

From Category;

IF Day( Today( 1) ) <=2 THEN

Concatenate (Example)

Load CatID,

CatName,

Desc,

UnitPrice,

UnitCost

From Category_NewDate;

END IF

Re: Append New Data

sunny_talwar — Thu, 12 May 2016 23:08:07 GMT

What would be the logic behind doing that? Is that something you would recommend even when setting variables? For instance

LET vToday = Today();

LET vTodat = Today(1);

Re: Append New Data

paulwalker — Thu, 12 May 2016 23:27:23 GMT

My requirement..

Here my 1st table standard data,

Month start first 2 days fetching new data from second data. (Here everyday refreshing data in database, but i don't need 3rd day onwards)

I want to append these 2 tables....

Re: Append New Data

swuehl — Fri, 13 May 2016 09:17:42 GMT

Sunny, if you want your variables to show the date of the script execution, I would recommend explicitely using timer mode 1.

There might not be a difference in using the default timer mode (2), but there were some changes and bugs in the past, and the only 'stable' function call was using timer mode 1.

Which also makes sense if you are really interested in getting the date of the function call /script execution and not in getting the date of opening the application (which apparently is most often the same date).

Tldr: I would recommend to use timer mode 1 in script function calls of today(1) / now(1), if it's only to make your choice explicite.

Re: Append New Data

swuehl — Fri, 13 May 2016 09:19:20 GMT

Paul, have you tried what has been suggested above? Is it not working for you?

If it is not working, could you describe a bit more detailed what issues you are seeing?

Re: Append New Data

sunny_talwar — Fri, 13 May 2016 09:25:36 GMT

That make sense.

Thanks for the explanation Stefan.

Best,

Sunny

Re: Append New Data

paulwalker — Sat, 14 May 2016 02:33:45 GMT

It's working.

Thank you

Re: Append New Data

Anonymous — Sat, 14 May 2016 09:03:52 GMT

by using the conncetate function or

where date >max(date)