How to get column that was existent before the cross tab

Hello,

So here is my scenario.

I have 5 columns before cross tab. Attached is the cross tab configuration(screenshot 1). Screenshot 2 are the columns after cross tab. Now the issue is I need the subplatform column that was there prior to cross tab. How do i get that back? Screenshot 3 shows columns before cross tab task.

Thanks

Screenshot 1.PNG

Screenshot 2.PNG

Screenshot 3.PNG

Common Use Cases

Accepted answers

grazitti_sapna

@zalakinc , Thereare 2 ways of doing it in both ways you will have to use Join tool to join the data before crosstab. Please find the attached workflow.

1. If Ref column is having unique values before crosstab then you can directly join the cross tab output with its input and get the desired result.

2. If Ref is not unique then you need to summarize Sub platform on Ref column and then join the results.

Please accept my solution if it helps!!

Thanks!!

New Workflow25.yxmd

All comments

Qiu

@zalakinc
Can you also check the Subplatform in the Group Data by these valves options in your first screenshot?

grazitti_sapna

@zalakinc , Thereare 2 ways of doing it in both ways you will have to use Join tool to join the data before crosstab. Please find the attached workflow.

1. If Ref column is having unique values before crosstab then you can directly join the cross tab output with its input and get the desired result.

2. If Ref is not unique then you need to summarize Sub platform on Ref column and then join the results.

Please accept my solution if it helps!!

Thanks!!

New Workflow25.yxmd

zalakinc

Thanks for detailed response

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703