Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Question on concatenation and same name fields

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.

1 Solution

Accepted Solutions
passionate
Specialist
Specialist

Hi Aaron,

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

Regards,

Pankaj

View solution in original post

4 Replies
passionate
Specialist
Specialist

Please post Sample data or Column names of both table.

Not applicable
Author

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
Specialist
Specialist

Hi Aaron,

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

Regards,

Pankaj

Not applicable
Author

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

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