topic Re: Need Help in QlikView

Need Help

Wed, 08 Jan 2014 15:30:44 GMT

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

Re: Need Help

Nicole-Smith — Wed, 08 Jan 2014 15:37:39 GMT

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;

Re: Need Help

Wed, 08 Jan 2014 16:01:06 GMT

Thank you! Nicole

When you know the answer it seems simple.

Re: Need Help

Wed, 08 Jan 2014 16:12:50 GMT

Good Work Nicoles...

Re: Need Help

Sat, 25 Jan 2014 15:21:59 GMT

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.......