How to Display one column information to other column information

[shabarish0587]

Hi Friends,

               I am facing one issue i.e. i have few columns like TKT_ID, PT_ID, CT_ID and ID. in CT_ID column i have few values like "P00" for these values i created a seperate column P_ID. my  issue is after creating P_ID column i want to get the values like if i select ID =2 i want to get the 2 rows  like this

Expected Output 1: When I select ID 2
ID	P_ID	TKT_ID	PT_ID	CT_ID
2	P00431	T00321	T00231	P00431
2	P00431	T00601	T00611	P00431

But i am getting the value only one row, i want to get two rows which for are linked with that p_ID while selecting any ID. I am sharing sample excel file , under this excel file i am sharing expected output. can any one help me on this . Thanks in Advance

[dplr-rn · Accepted solution]

You will need to use set analysis

e.g. below

Only({<ID=,P_ID=p(P_ID)>} exampl)

[Brett_Bleess]

Did Dilip's set analysis suggestion work?  If so, please be sure to use the Accept as Solution button to mark things, which will give him credit and let others know that worked.  If you are still working on things, leave an update, and if you did something else, consider posting that for others, and you can then mark that as the solution as well.

The best I can add here is it likely has to do with the data model etc. and the expression seeing the two rows as identical, which will result in a single row in that case, as we collapse duplicates.  There are some ways to change this behavior in the load script as well, you could use RowNo() or RecNo() functions potentially to be sure each row in the data is unique, that might be another workaround here possibly.  

Regards,
Brett