Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need Help

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

1 Solution

Accepted Solutions
Nicole-Smith

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;

View solution in original post

4 Replies
Nicole-Smith

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;

Not applicable
Author

Thank you! Nicole

When you know the answer it seems simple.

Not applicable
Author

Good Work Nicoles...

Not applicable
Author

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