No Concatenate

[markgraham123]

Hi all,

I have a doubt to get clarified

Am i on the right track using "No Concatenate".?????

1:

Load A, B from xyz;

No Concatenate

2:

Load A, B from abc;

No Concatenate

3:

Load * Resident 1;

Outer Join

Load * Resident 2;

Drop Tables 1,2;

[#2]

Try like below:

1:

Load A, B from xyz;

2:

NoConcatenate

Load A, B from abc;

3:

NoConcatenate

Load * Resident 1;

Outer Join(3)

Load * Resident 2;

Drop Tables 1,2;

[markgraham123]

Does that make any difference??

Please let me know as i'm a new learner.

[#4]

I don't think so.

What o/p you are  expecting ?

[#5]

I write like that way its more readable to others & what i am trying.

[Qrishna · Accepted solution]

1:

Load A, B from xyz;

No Concatenate

2:

Load A, B from abc;

No Concatenate

3:

Load * Resident 1;

Outer Join

Load * Resident 2;

Drop Tables 1,2;

1:

Load A, B from xyz;

2:

No Concatenate

Load A, B from abc;

3:

No Concatenate

Load * Resident 1;

Outer Join

Load * Resident 2;

Drop Tables 1,2;

are same.

its the readability difference.Thats all.

[markgraham123]

Table 1 contains 2014 data and

Table 2 contains 2015 data.

I wanna join both.

In the end, can i please know how can i count total num. of lines in our app.

[markgraham123]

Table 1 contains 2014 data and

Table 2 contains 2015 data.

So, i wanna join both to get single qvd of two years.

Am i on right track?

[Qrishna]

Do you want to join or concatenate 2015 data t0 2014 data?

if  both tables have same fields then you could easily concatenate.

[#10]

Simply remove the Concatenate in your script. So two tables auto concatenated and you can select either 2014 or 2015.

Concatenate is equal to UNION operator in SQL