Need Help

[#1]

Hi Community,

Table1:

LOAD * Inline

[key,Value

1,A016];

Table2:

LOAD * INLINE [

Order Date, Material No,  Ordered Qty,ID

2-11-2013,  28112,           300,             1

8-1-2014,    34112,          200,              2

24-11-2013, 45112,          300,             3

24-11-2013, 9876,          250,             4

05-12-2015, 1237,            80,              5

06-12-2013, 1234,            30,               6

];

I want concatenate 2 fields, all Meterial No(Table2) with Value(Table1)

Like this

Material & Value=28112A016

Thanks In Advance

[Nicole-Smith · Accepted solution]

See the attached.

Table1:

LOAD * Inline

[key,Value

1,A016];

outer join (Table1)

LOAD * INLINE [

Order Date, Material No, Ordered Qty,ID

2-11-2013, 28112, 300, 1

8-1-2014, 34112, 200, 2

24-11-2013, 45112, 300, 3

24-11-2013, 9876, 250, 4

05-12-2015, 1237, 80, 5

06-12-2013, 1234, 30, 6

];

TableFinal:

LOAD *,

     [Material No] & [Value] as [Material & Value]

RESIDENT Table1;

DROP TABLE Table1;

[#3]

Thank you! Nicole

When you know the answer it seems simple.

[#4]

Good Work Nicoles...

[#5]

Hi Nicole,

PFA,

Already i made application,..

In SHEET1 i have Final ASN_Qty calculated field,  in this i have NULL() and -VE values..  i want to convert with 0.

this column i am using another step.. but i have NULL() fileds that's why it shows not proper data.......