topic Re: Question on concatenation and same name fields in QlikView

Question on concatenation and same name fields

Wed, 25 Nov 2020 16:16:04 GMT

I have a qvw that does incremental loads on different data, say Projects data and Cases Data

Projects and Cases share many same field names, like ID, CustomerName, etc

My question is, when I do incremental loads for each, will the data merge together and be loaded in together? I don't want that

My process:

I do the incremental load for Projects first,

Load ProjNewData.

Concatenate ProjNewData with ProjOldData.

Then cases, Load CaseNewData

concatenate CaseNewData with CaseOldData

If Projects has same field names as cases, when I "Load" it in, does it stay loaded and then somehow the cases load joins with those fields?

Or does it work as intended and only concatenates the given data right before it.

Re: Question on concatenation and same name fields

passionate — Fri, 28 Jul 2017 17:34:25 GMT

Please post Sample data or Column names of both table.

Re: Question on concatenation and same name fields

Fri, 28 Jul 2017 18:54:29 GMT

NewProjects:

LOAD Account,

[Accepted Date],

[DMSi Customer ID],

Billable,

Canceled,

Category,

Subcategory,

Source,

[Project Filter],

[Completed Date],

[Record Type],

[Created At],

[Updated At],

[ID]

FROM

(ooxml, embedded labels, table is Export);

Concatenate(NewProjects)

LOAD

* from

O:\QVD\ProjectsReport.qvd (qvd)

where not exists(ID)

and date#([Accepted Date]) >= today() - 731;

Store NewProjects into O:\QVD\ProjectsReport.qvd;

Then in the next tab, for cases,

NewCases:

LOAD Account,

Billable,

[Billing Type],

[Case #],

Category,

Subcategory,

[Created At],

[Closed Date],

Status,

[DMSi Account ID],

[Billing Amount Final],

[Case Type],

[ID]

FROM

(ooxml, embedded labels, table is Export);

Concatenate(NewCases)

LOAD

* from

O:\QVD\CasesReport.qvd (qvd)

where not exists(ID)

and date#([Accepted Date]) >= today() - 731;

As you can see, they share a lot of fields. I don't want the values in the fields in Projects to carry over to Cases since they are "loaded" in. Does that make sense?

Re: Question on concatenation and same name fields

passionate — Fri, 28 Jul 2017 19:28:55 GMT

Hi Aaron,

No they won't be interacting. But, They would be treated as separate tables and not concatenated.

Regards,

Pankaj

Re: Question on concatenation and same name fields

Fri, 28 Jul 2017 19:47:59 GMT

Okay. You mean projects wont be concatenated onto Cases right?

But the inner concatenation between Old and New Projects will still take place.