Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: row flattener...unable to get the required result for my query...

  1. #1

    Exclamation row flattener...unable to get the required result for my query...

    hi all,
    i have my input like

    metric_id metric_count
    1 12
    2 6
    3 11
    4 9
    6 14

    for each metric_id there is metric_name like 1-aa,2-bb, 3-cc, 4-dd, 5-ee,6-ff

    i have used row flattener to make rows into columns...
    here iam getting output like..

    aa bb cc dd ee ff
    12 6 11 9 14


    the result should be like

    the result i have saved in my attachment.. kindly check it out... iam facing problem in text editing in this forum so i have used attachment...

    actually 14 should come under ff.. but its lying under ee because 5 number is missing..

    can any one find a perfect solution for this query..


    thanks & regards
    Attached Files Attached Files
    Last edited by kirankumar_ganapuram; 03-24-2011 at 02:47 AM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.