Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: rshah20713; Keyword(s):

Search Forums: Search took 0.02 seconds.

  1. Replies
    5
    Views
    623

    Thanks for replying @marabu, however there are 2...

    Thanks for replying @marabu, however there are 2 points here:

    1. This is a system generated file, so tweaking becomes a manual activity.
    2. Not all records have city mentioned.
  2. Replies
    5
    Views
    623

    .csv replacing values of other columns

    Dear All,

    I have a system generated file which comes in .csv format.
    The problem is that one of the columns (Customer Name) contains the city name as well. This is separated with comma ( , ).
    ...
  3. Replies
    8
    Views
    932

    Thanks a ton!!! Apologies for the late...

    Thanks a ton!!!
    Apologies for the late reply....Combination of both replies worked out for me... :)
  4. Replies
    8
    Views
    932

    Sorry for the late reply....Thank a lot!!!

    Sorry for the late reply....Thank a lot!!! The solution you both provided worked for me....Once again thanks a ton!!!
  5. Replies
    8
    Views
    932

    Attached sample file...Thanks for your help!!!

    Attached sample file...Thanks for your help!!!
  6. Replies
    8
    Views
    932

    Nicely explained Isha Lamboo...

    Nicely explained Isha Lamboo !!!! Thank you very much!!!
    Got success to an extent, however unable to get rid of "--------". This line is repeated after every 100 records.
    If I got rid "--------"...
  7. Replies
    8
    Views
    932

    Convert .csv to excel (TAB delimited)

    Dear Gurus,

    Any help on this would be much appreciated...

    I get a set of files from Credence(Treasury application) on daily basis in .csv format (TAB delimited).
    Along with the data there's...
  8. Replies
    1
    Views
    880

    Excel to Excel Mapping

    Dear Experts....

    I have a requirement for excel to excel mapping...2 Excels, Different column names in source and target. Need a column mapper.

    Eg: I have a input as excel workbook which...
  9. SQL Query as a part of output just like SQL Developer Excel Output

    Hi Everyone,

    I am using Kettle Spoon Stable 4.4.0

    I have to deal with data extraction requests from my users and sometimes I tend to misplace the query the query used for an output.

    So,...
  10. Dump of 39 lakh rows in excel from table input

    Hi Folks....
    Firstly thank you very much for taking out time to read my post and trying to help me out....
    I am using Kettle CE 4.4

    Our situation is such that we want to take a dump from table...
  11. Hi Mick.... Thanks a ton for replying... I...

    Hi Mick....
    Thanks a ton for replying...


    I just created a quick sample.
    I have created 2 excels and used them as input.
    I just wanted to know more about sorting the rows.
    I have got 2...
  12. Replies
    4
    Views
    753

    Appreciate your response due to few manual...

    Appreciate your response due to few manual processes my Customer Master gets updated in excel.
    Then we have to identify through name and all other fields.

    However thanks for the response. :)
  13. Replies
    4
    Views
    753

    Hey Folks, I did some searching and was able...

    Hey Folks,

    I did some searching and was able to find the solution (probably this might be the answer).
    There is some problem with the engine for .xlsx [Excel 2007 XLSX (Apache POI)] in Excel...
  14. Replies
    4
    Views
    753

    OutOfMemory: Java heap space

    Hello Everyone,

    I am using Spoon (Kettle CE stable 4.4.0)
    I have an excel input with more than 20,000 rows.
    Now while trying retrieve the sheetname Sppon gives me the attached error.
    Has anyone...
  15. Apologies for that Gutlez...missed out the main...

    Apologies for that Gutlez...missed out the main question. :p

    My problem is that the left out join doesn't work as expected and there are duplicates from the right excel input.
    As per the below...
  16. Left Outer Join - Not Working with Excel Input

    Hi Folks,

    I m using Kettle 4.4 community edition stable.

    I have 2 excel files as input.
    1. Cust_Master contains cust_id column
    2. Some financial data with cust_id ​column
    Now I am using...
  17. Seems this topic isnt picked up by anyone....

    Seems this topic isnt picked up by anyone.
    Appreciate any input for this...
    Thank you in advance...
  18. Replies
    2
    Views
    524

    Seems no is picking up this topic though there...

    Seems no is picking up this topic though there are a lot of views...
    Request you to give some assistance.
    Thank you very much....
  19. Replies
    3
    Views
    747

    I did get Unique records function in PDI, did try...

    I did get Unique records function in PDI, did try that as well but never got expected output.

    In fact it merges all records (Obviously there were no duplicates) but I wanted to dump duplicates and...
  20. Replies
    8
    Views
    18,184

    Hey joao.ciocca, Thanks for the links...I did...

    Hey joao.ciocca,

    Thanks for the links...I did google about RegEx and UDJE got this link
    http://wiki.pentaho.com/display/EAI/Regex+Evaluation
    Hopefully I do get more info for the same.
  21. Transformation stops if encountered errors

    Hi Everyone,

    I am using Spoon (Kettle 4.4 CE stable)

    Now I have 23 Excel files and need to convert all of them into .csv with | (pipe) delimited.
    I was able achieve this in one single...
  22. Replies
    2
    Views
    524

    Logging Transformations

    Hey Experts,

    Just one query here...I am using Spoon for small conversions and replacing texts, etc.
    My transformations dont get connected to any DB, rather all inputs are Excel files.
    Is there a...
  23. Replies
    3
    Views
    747

    Split Duplicates from Excel Input

    Hello Everyone,

    I am currently using Spoon (Kettle 4.4 stable)

    Now I have a requirement as below:

    1. Compare Company Name from 3 excel files [This file has only Company Names (which is...
  24. Replies
    8
    Views
    18,184

    Thanks guys... I guess I have found the solution...

    Thanks guys...
    I guess I have found the solution to my problem...
    The RegEx was set to Y [don't know much about RegEx]
    But I did set RegEx to N and Whole Word to N.
    For now it does get me...
  25. Replies
    8
    Views
    18,184

    Hey joao.ciocca, Thanks a lot for your...

    Hey joao.ciocca,

    Thanks a lot for your response...Did understand your explanantion..will try that for sure...
    I will give the sample data for your reference, also i have attached the image of the...
  26. Replies
    8
    Views
    18,184

    Using "Replace in String"

    Hello Everybody,

    I am new to Pentaho Kettle CE 4.4 (Stable)
    My requirement is to read the Cust_Name from an excel input and replace the below characters/string in the values.

    1. Any kind of...
  27. Replies
    8
    Views
    2,327

    Just an update... I was able to view the cube...

    Just an update...
    I was able to view the cube and schema name in JPivot view.
    However I was not able to use that's a different issue altogether.
    Only when I try in Saiku, it doesn't even show the...
  28. Replies
    8
    Views
    2,327

    Hi Folks, I am still unable to get anything on...

    Hi Folks,

    I am still unable to get anything on this.
    The OLAP folder is not visible or its missing.
    While publishing the cube it doesnt ask for path name while publishing.
    I have Oracle XE...
  29. Hey folks, I was wondering why my cube aren't...

    Hey folks,

    I was wondering why my cube aren't showing up in Saiku window.
    Also when I publish the cube it just simply exports and doesnt ask me for any folder path.
    There were some posts I read...
  30. Hi Gutlez, I have Java 1.7u79, still would try...

    Hi Gutlez,

    I have Java 1.7u79, still would try this out.
    Thanks!!!
  31. Replies
    8
    Views
    2,327

    Thanks folks for replying, I am using...

    Thanks folks for replying,

    I am using Community Edition of Pentaho BI Server.
    I was wondering where can I locate the Log files, will it be in one of the folders or the window which is active...
  32. Hi mcampbell, No, but any kind of action like...

    Hi mcampbell,

    No, but any kind of action like New>Schema, MDX, etc does get frozen.
    Where are the logs saved or is it the command prompt window which is active while working on PSW.
    Thanks for...
  33. Replies
    8
    Views
    2,327

    Request all to please reply. Is there something...

    Request all to please reply.
    Is there something that I have missed out?
    I am unable to understand why Saiku isnt able to pickup the Cube so created :(:(:(
  34. Replies
    8
    Views
    2,327

    Hey Folks, Just to update more the issue. I...

    Hey Folks,

    Just to update more the issue.

    I am using Saiku-Plugin-p5-3.3.2.
    The Cube so published is not visible when Saiku is launched.

    Any responses is highly appreciated!!!
  35. Replies
    8
    Views
    2,327

    Publishing a basic test cube

    Hi Folks,

    I am new to Pentaho Schema Workbench CE on Windows 7.

    Versions:
    BI Server CE 5.4.0.1-130
    Pentaho Schema WorkBench CE 3.10.0.1-130

    Database:
    Oracle XE 11gR2
  36. Ways to Self Service Reporting in Pentaho CE

    Hi Folks,

    What can be other ways of creating a self service reporting in Pentaho CE.
    I have Bi Server CE 5.4.0.1-130 and Schema Workbench CE 3.10.0.1-130.
    Is there any other tool we can use...
  37. Schema Workbench freezes after ODBC connection

    Hi Folks,

    I am new to Pentaho Community Edition.
    My requirement is to create self service reporting.
    I have BI sever CE 5.4.0.1-130.
    I have Schema Workbench CE 3.10.0.1-130.
    Now the issue is...
  38. Hello Johanhammink and Emicarnicero, I did...

    Hello Johanhammink and Emicarnicero,

    I did download the PSW (psw-ce-3.10.0.1-130) and was trying to create a basic cube.
    As I create a ODBC connection and click on new Schema/MDX/JDBC, PSW...
  39. Thank you Johanhammink and Emicarnicero!!! Will...

    Thank you Johanhammink and Emicarnicero!!!
    Will try my hands on with PSW and hopefully this should solve my queries.
    Thank you as this encourages newbies like us to explore more and more!!!
    Thank...
  40. Hi Emicarnicero, So through Pentaho Schema...

    Hi Emicarnicero,

    So through Pentaho Schema Workbench, we can create cubes or measures and dimensions.
    Also is there a Pentaho Schema Workbench Community Edition that is available for download?...
  41. Hello everyone...Please do respond...It would be...

    Hello everyone...Please do respond...It would be much appreciated!!!
  42. Thanks Emicarnicero for replying!!! So Saiku is...

    Thanks Emicarnicero for replying!!!
    So Saiku is the way for reporting in Pentaho Community Edition (I have biserver-ce-5.4.0.1-130).
    I did see the plug-in for Saiku, but how do I get the measures...
  43. Reporting in Pentaho Community Edition

    Hello Everyone,

    I am new to Pentaho Community Edition.
    I have installed Pentaho Community Edition (BI Server 5.4.0.1-130).
    Now I wanted start creating Grid, Charts,etc. reporting through Pentaho...
  44. Can users create new reports in Pentaho Community Edition

    Hello Everyone,

    I have installed Pentaho Community Edition and want to know if my users can create new reports in Pentaho Community Edition.
    If Yes, then how do i make the measures and dimension...
  45. Reporting tools in Pentaho Community Edition

    Hello Everyone,

    I am new to pentaho Community Edition.
    I have installed Pentaho Community Edition.
    The user console works fine!!!
    However, now I wanted to know how can we start basic Adhoc...
  46. How can we using DB Functions (Concat, Datepart, etc)

    Hi All,

    I am new to Pentaho. I have installed the trail version and trying to create a basic report.
    My DB is Oracle XE 11 R2 and I was trying to concatenate firstname and lastname in Pentaho...
Results 1 to 46 of 46
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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