Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;
Thank you! Nicole
When you know the answer it seems simple.
Good Work Nicoles...
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.......