Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI ziadmohd1
I Have a pivot table with 5 dimension as shown below
If the pro# number is same i want to concate the two records.r merge two records .How can we acheive it
Expected result :
Sender | BL Num | Pro # | mlstn_bol_awb_nbr | mlstn_pro_awb_nbr | Milestone Type All | Supplier Booked w/FF | Carrier Departed Pick-up Location with Shipment | Departed Origin Port Location | Estimated to Arrive at Destination Port | Estimated Date and/or Time of Arrival at Consignee’s Location | Arrived at Destination Port | Arrival at Consignee's Location |
TQI | 2000000832158 | 82006 | 82006 | 82006 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | |
2000000832159 |
Hi Naveen
Try to move PRO# as the second dimension .. or else please send a sample qvw
In a straight table, you can convert BL_Num (the only one that has different values for the same Pro# value) into an expression using concat() and move i to second position.
In a pivot table however, I don't think this will be possible as you are using a horizontal dimension, and all expressions (even those that are actually translated dimensions) will be repeated for every single horizontal dimension value. Pivot table objects are more restricted in their layout and flexibility.