Skip to Content
-1

How to Suppress Line ID wise data

Mar 25, 2017 at 07:06 AM

42

avatar image

Hi All,

How to Suppress Line ID wise data

Select
----T0."DocEntry" As "DocKey",t0."Series",T6."BeginStr" As "SeriesName" ,
T0."DocNum" As "DocNo.",
T0."DocDate" As "Dated",

----tEST-----------------------------------------------------------
CASE
WHEN (T1."LineNum") = '0' THEN T1."U_UNE_BLDT"
END AS "1",
CASE
WHEN (T1."LineNum") = '1' THEN T1."U_UNE_BLDT"
END AS "2",
CASE
WHEN (T1."LineNum") = '2' THEN T1."U_UNE_BLDT"
END AS "3",
CASE
WHEN (T1."LineNum") = '3' THEN T1."U_UNE_BLDT"
END AS "4",
CASE
WHEN (T1."LineNum") = '4' THEN T1."U_UNE_BLDT"
END AS "5",
CASE
WHEN (T1."LineNum") = '5' THEN T1."U_UNE_BLDT"
END AS "6",
CASE
WHEN (T1."LineNum") = '6' THEN T1."U_UNE_BLDT"
END AS "7",
CASE
WHEN (T1."LineNum") = '7' THEN T1."U_UNE_BLDT"
END AS "8",
CASE
WHEN (T1."LineNum") = '8' THEN T1."U_UNE_BLDT"
END AS "9",
CASE
WHEN (T1."LineNum") = '9' THEN T1."U_UNE_BLDT"
END AS "10",
CASE
WHEN (T1."LineNum") = '10' THEN T1."U_UNE_BLDT"
END AS "11",
CASE
WHEN (T1."LineNum") = '11' THEN T1."U_UNE_BLDT"
END AS "12",
CASE
WHEN (T1."LineNum") = '12' THEN T1."U_UNE_BLDT"
END AS "13",
CASE
WHEN (T1."LineNum") = '13' THEN T1."U_UNE_BLDT"
END AS "14",
CASE
WHEN (T1."LineNum") = '14' THEN T1."U_UNE_BLDT"
END AS "15",
CASE
WHEN (T1."LineNum") = '15' THEN T1."U_UNE_BLDT"
END AS "16",
CASE
WHEN (T1."LineNum") = '16' THEN T1."U_UNE_BLDT"
END AS "17",
CASE
WHEN (T1."LineNum") = '17' THEN T1."U_UNE_BLDT"
END AS "18",
CASE
WHEN (T1."LineNum") = '18' THEN T1."U_UNE_BLDT"
END AS "19",
CASE
WHEN (T1."LineNum") = '19' THEN T1."U_UNE_BLDT"
END AS "20",
CASE
WHEN (T1."LineNum") = '20' THEN T1."U_UNE_BLDT"
END AS "21",
CASE
WHEN (T1."LineNum") = '21' THEN T1."U_UNE_BLDT"
END AS "22",
CASE
WHEN (T1."LineNum") = '22' THEN T1."U_UNE_BLDT"
END AS "23",
CASE
WHEN (T1."LineNum") = '23' THEN T1."U_UNE_BLDT"
END AS "24",
CASE
WHEN (T1."LineNum") = '24' THEN T1."U_UNE_BLDT"
END AS "25"
----END---------------------------------------------

from OIGN T0
Inner Join IGN1 T1 On T0."DocEntry" = T1."DocEntry" and t1."BaseType"='-1'
Left Join OITM T13 On T1."ItemCode" = T13."ItemCode"
Left join NNM1 T6 On T0."Series" = T6."Series"
left join OCRD T14 on T0."U_UNE_VENDC"= T14."CardCode"

ij98i.png (331.2 kB)
SQL
10 |10000 characters needed characters left characters exceeded

Please be more specific about your use case here. What do you want to achieve here?

Something like collapsing/aggregating multiple rows into one? Or is this supposed to be a hand-written pivot transformation?

By looking at your query and the screenshot I can't figure out, what you want to achieve.

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers