topic Re: Concatenate part does not load in QlikView

Concatenate part does not load

tanjavarwijk — Thu, 28 Jun 2012 14:44:59 GMT

Order:

LOAD "Document Type" as Order_Type,
      "Document No_"&"Line No_" as Order_Entry_Nr,
      "No_" as Order_Item_Nr,
     'Inkoop' as Order,
     "Outstanding Quantity" as Order_Outstanding,
     1 as Order_Counter,
     "Order Date" as Order_Date
     ;
     SQL SELECT
     "Document Type",
     "Document No_",
      "Line No_",
      "No_",
     "Outstanding Quantity" ,
     "Order Date"
     FROM $(DB_CONSTRING)Purchase line"
     ;

Concatenate
LOAD "Document Type" as Order_Type,
      "Document No_"&"Line No_" as Order_Entry_Nr,
      "No_" as Order_Item_Nr,
     'Sales' as Order,
     "Outstanding Quantity" as Order_Outstanding,
     1 as Order_Counter,
     "Order Date" as Order_Date
     ;
     SQL SELECT
"Document Type",
     "Document No_",
      "Line No_",
      "No_",
     "Outstanding Quantity" ,
     "Order Date"
     FROM $(DB_CONSTRING)Sales Line"
;

Re: Concatenate part does not load

giakoum — Thu, 28 Jun 2012 14:50:25 GMT

This seems to work. I removed " from Purchase line" and Sales Line"

Order:

LOAD "Document Type" as Order_Type,

"Document No_"&"Line No_" as Order_Entry_Nr,

"No_" as Order_Item_Nr,

'Inkoop' as Order,

"Outstanding Quantity" as Order_Outstanding,

1 as Order_Counter,

"Order Date" as Order_Date

;

SQL SELECT

"Document Type",

"Document No_",

"Line No_",

"No_",

"Outstanding Quantity" ,

"Order Date"

FROM $(DB_CONSTRING)Purchase line

;

Concatenate

LOAD "Document Type" as Order_Type,

"Document No_"&"Line No_" as Order_Entry_Nr,

"No_" as Order_Item_Nr,

'Sales' as Order,

"Outstanding Quantity" as Order_Outstanding,

1 as Order_Counter,

"Order Date" as Order_Date

;

SQL SELECT

"Document Type",

"Document No_",

"Line No_",

"No_",

"Outstanding Quantity" ,

"Order Date"

FROM $(DB_CONSTRING)Sales Line

;

Re: Concatenate part does not load

tanjavarwijk — Thu, 05 Jul 2012 06:51:32 GMT

Solved by using SQL SELECT *

Re: Concatenate part does not load

tanjavarwijk — Thu, 05 Jul 2012 06:51:59 GMT

Solved by using SQL SELECT *