Unlink the coluns created with Alias

[mateusgerin]

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.

[dplr-rn]

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.

[mateusgerin]

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.

[mateusgerin]

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