Concatenate Issues

[ajsjoshua]

Hi all,

Good Morning.

I have two tables which i want to concatenate.

table1:         table2:

week,          week,

Year             Year

But i need only table 1 Year.

How to achieve it.

Regards,

Joshua.

[arulsettu]

like this

table1:       

week,        

Year     

concatenate (table1)

       table2:

       week,

       Year

[#3]

Hi,

For what reason you want to concatenate, Do you only want to have records which are available in Table 1

[MindaugasBacius]

If I caught your issue correct you do not need Table 1 field Year. Try this:

Table1:
Load Week
     ,Year
     ,Other_fields
From source_Table1;

concatenate (Table1)
Load Week
     ,Other_fields
From Source_Table2;

[settu_periasamy]

Try this

T1:

Load Week, Year from source1;

Concatenate (T1)

Load Year,Week from source2 where exists (Year);

[ajsjoshua]

Hi,

Actually in table 1 year (2014,2015,2016)

but in table 2 year(2014,2015,2016,2017,2018)

I want only (2014,2015,2016)

[ajsjoshua]

Hi settu_periasamy

Its affecting other fields .

Some fields depends on the year field.

Thanks and Regards,

Joshua.

[ajsjoshua]

Hi mindaugasbacius

Its affecting other fields .

Some fields depends on the year field.

Thanks and Regards,

Joshua.

Concatenate Issues

[arulsettu]

try this

table1:      

week,       

Year    

concatenate (table1)

       table2:

       week,

       Year

where noth match(Year,'2017','2018');

[#10]

Hi,

When you need only the data wrt to year in table 1, you can go for a left join.

T1:

Load * INLINE [

Week, Year

1, 2014

2, 2015

3, 2016

];

NoConcatenate

T2:

LOAD * INLINE [

Week, Year

1, 2014

2, 2015

3, 2016

4, 2017

5, 2018

];

Left Join(T1)

Load

  Year,

  Week as W1

Resident T2;

Drop Tables T2;