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.

[#2]

Hi,

If you wanted to look data of table2 based on week selection on the UI, then you need to concatenate week to table1

[susovan]

Hi joshua,

You can also try this,

Table1:

LOAD week,

     year as Year1

FROM

Table1.xlsx

(ooxml, embedded labels, table is Sheet1);

Table2:

LOAD week,

     year

FROM

Table2.xlsx

(ooxml, embedded labels, table is Sheet1);

Concatenate

LOAD year as Year1

Resident Table2

Where not Exists(Year1,year);

[effinty2112]

Hi Joshua,

                    I don't see any reason why you can't include the fields you want in the concatenation.

Concatenate (table1)

Load

week,

Year,

Field1,

Field2,

.

.

From  ...SourceOftable2 Where Exists(Year);

If you don't get the result you expect let me know and we'll probably need to discuss your application in a bit more detail.

Cheers

Andrew

[Anil_Babu_Samineni]

Joshua,

In this case, Why you want to use T2 Data. Just use T1 Data directly.

OR

For 2014 Data put Flag and then use manually for Year from T2 Data

- ANIL

[Peter_Cammaert]

AFAIK settu_periasamy's suggestion is the right one for your original request (concatenate only Table 2 rows in a Year that exists in Table 1). Did you try it out? Which other fields are affected?

Peter

[ajsjoshua]

Hi ,

PFA

i want to concatenate the fact and fact1

My calendar is week from fact

IF i select week 36 and LITM 10327510

My order is 16.80

For week 36 and LITM 1064464

My GIT is 13.80

If i select week 32 and LITM 10327515 my RecvdQTy * conversionfactor is 1.61

[ajsjoshua]

Hi pcammaertloveisfail

Pls see the applicaton uploaded.

Thanks and Regards,

Joshua.

[squeakie_pig]

Maybe the Keep function is what you need

Understanding Join, Keep and Concatenate

[ajsjoshua]

Hi all,

Any other suggestions