Concatenate creating loop causig unwanted results...

Wed, 09 Oct 2013 10:54:46 GMT

I have two tables Incidents as the follwing

1. Union and

2. Tagged incidents

and both the above table are having the incident open_date_time

and have created a master calendar with Unions open_date_time which is working fine, however the same is not when tried concatenating the open_date_time of the Union with the Tagged incidents.

The script is as follows, when executed causing warnings as Loop are been creating which can cause unwanted results.

Union:

LOAD Id as Ticket_Id,
Open_DateTime,
MakeDate(year(Open_DateTime),Month(Open_DateTime),day(Open_DateTime)) as Date,
FROM
..\Data\Raw QVDs\Union(qvd);

[Tagged Incidents]:

LOAD Id,
Id as [Problem Id],
Open_DateTime,
FROM
..\Data\Raw QVDs\Tagged_Incidents(qvd);

when tried to concatenate two dates using the below script getting un desired results,

UNQUALIFY *;
DateLink:
LOAD

Distinct Union.Open_DateTime,
MakeDate(year(Union.Open_DateTime),Month(Union.Open_DateTime),day(Union.Open_DateTime)) as Date

Resident Union;
Concatenate(DateLink)
LOAD

Distinct

[Tagged Incidents.Open_DateTime],
MakeDate(year([Tagged Incidents.Open_DateTime]),Month([Tagged Incidents.Open_DateTime]),day([Tagged Incidents.Open_DateTime])) as Date

Resident

[Tagged Incidents];

Please suggest as how to avoid the circular reference and loops...

Re: Concatenate creating loop causig unwanted results...

swuehl — Wed, 09 Oct 2013 11:26:07 GMT

I assume your first two tables are fully qualified, right?

So there is no direct link between these two tables and no link to another table other than DateLink?

It's quite hard to see the issue with just the script snippet. Please post a screen shot of your table viewer, a more complete script export or at best a small sample app that demonstrate your issue (you can / should replace DB loads with some INLINE table mock up data then).

topic Concatenate creating loop causig unwanted results... in QlikView

Concatenate creating loop causig unwanted results...

Re: Concatenate creating loop causig unwanted results...