Question on concatenation and same name fields

[#1]

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.

[passionate]

Please post Sample data or Column names of both table.

[#3]

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?

[passionate · Accepted solution]

Hi Aaron,

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

Regards,

Pankaj

[#5]

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

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