Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All!
Please, i need some help here 🙂
I need to extract/filter the data from the same column ("Business Partner Number") based on the values in another column ("Partner Function") as shown in the example:
LOAD
"Custom_Document_Header.Primary Key" as ID,
if ("Partner Function" = 'ZCUSVKA', "Business Partner Number") as BILL_FROM,
if ("Partner Function" = 'ZCUSREM', "Business Partner Number") as BILL_T0
...
The scrip worked correctly but I can not use both columns at the same time .. if I select one the other is disabled 😑
Thanks for the help.
Sounds like you may need to do use set analysis and possibly island tables rather than doing it in script.
Am i right in thinking you want to see items billed from A and billed to B
If you can share a sample data can try and help.
Hi Dilipranjith!
Yes, I have different values in the same column, so I need to separate the values of each group into a different column.
For example:
AS IS:
Partner_Function | Business Partner_Number |
A | 11168033 |
B | 8163122 |
C | 8155562 |
C | 8337549 |
B | 8337550 |
TO BE:
Partner A | Partner B | Partner C |
11168033 | 8163122 | 8155562 |
8337550 | 8337549 |
Attached we can see a sample.
Thanks a lot.
Does anyone know how to achieve this result?
Partner_Function | Business Partner_Number |
A | 11168033 |
B | 8163122 |
C | 8155562 |
C | 8337549 |
B | 8337550 |
Expected:
Partner A | Partner B | Partner C |
11168033 | 8163122 | 8155562 |
8337550 | 8337549 |