topic Re: Unlink the coluns created with Alias in App Development

Unlink the coluns created with Alias

mateusgerin — Sat, 16 Nov 2024 20:34:38 GMT

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.

Re: Unlink the coluns created with Alias

dplr-rn — Wed, 26 Jun 2019 13:47:44 GMT

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.

Re: Unlink the coluns created with Alias

mateusgerin — Wed, 26 Jun 2019 15:13:16 GMT

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.

Re: Unlink the coluns created with Alias

mateusgerin — Wed, 26 Jun 2019 19:52:01 GMT

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