How to get column that was existent before the cross tab

[zalakinc]

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

[Qiu]

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

[grazitti_sapna · Accepted solution]

@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!!

[zalakinc]

Thanks for detailed response