Can we concatinate String value table with integer value table

[#1]

Hi Qv,

can we concatinate below two tables ,one table have sum of integer values another table value have string.

table1:

Dim1	PRIOR WEEK Data	PRIOR MONTH DATA
101	25	35
102	50	68
103	12	26
104	35	45

table2:

Dim2	PRIOR WEEK Data	PRIOR MONTH DATA
TIMELINE	WK17	WK13-WK17

output look like this.

DIM1	PRIOR WEEK DATA	PRIORMONTH DATA
TIMELINE	WK17	WK13-WK17
101	25	35
102	50	68
103	12	26

Thanks

[Anonymous]

Yes you can, give it a go !!

[#3]

Thax bill,

Can you pls elobarate more with example qvw I am unable to get the output like above

I have used Dimestion as Dim1  and expressions like sum(PRIORWEEKDATA),sum(PRIOR MONTHDATA) but unable successed .

[swapnil_kumbhar]

Yes you can.

PFA

[#5]

Hi,

TABLE1:

LOAD *

FROM table1.xlsx;

CONCATENATE (TABLE1)

LOAD *

FROM table2.xlsx;

Regards,
Marius

[manideep78]

Hi SwathiRaj P

Try this:

Table1:

LOAD * INLINE [

    Dim1, Week, Month

    101, 25, 35

    102, 50, 68

    103, 12, 26

    104, 35, 45

];

Table2:

Concatenate

LOAD Dim2 as Dim1,*;

LOAD * INLINE [

    Dim2, Week, Month

    Timeline, WK17, WK13-WK17

];

Drop Field Dim2;

It should work.

Hope this helps you.

Regards,

Manideep

[#7]

It should be fine in table box,.....can we get same output in straight table by using  expressions like sum(PRIORWEEKDATA),sum(PRIOR MONTHDATA) .

Thanks

[#8]

can we get same output in straight table instead of table box.

[#9]

ya, just concatenate in script

[manideep78]

PFA