Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
If you wanted to look data of table2 based on week selection on the UI, then you need to concatenate week to table1
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);
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
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
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
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
Maybe the Keep function is what you need
Hi all,
Any other suggestions