armel.qojdeshi_1 Posted January 5, 2017 Share Posted January 5, 2017 Hello!I am trying to insert a column with multiple values in an existing table. i did a first job, creating a table X with some column and now i want to add in the table X new columns. I tried insert in action in the datatabase and default action in table and when i am seeing the table in mysql nothing is added. PS: iam very fresh in japersoft etlThank youArmel Link to comment Share on other sites More sharing options...
reportdev Posted January 5, 2017 Share Posted January 5, 2017 after evaluating the sql in the dataset and query window, the fields will be added to the table element.after adding,double click on the table elementexpand the Table -> click on any of the bands and expand (Table Header / Column Header / Detail / Column Footer/Table Footer)you should see columns.right click on one of the columns and click Create Column after or Create Column Before Link to comment Share on other sites More sharing options...
hozawa Posted January 5, 2017 Share Posted January 5, 2017 Ok, the question is about Jaspersoft ETL and not about JasperReports librarry.Which component are you using? Link to comment Share on other sites More sharing options...
armel.qojdeshi_1 Posted January 6, 2017 Author Share Posted January 6, 2017 thanks for your comment!I have 3 excel files and i want to find erros in the data inside the files. i found the erros using inner join with the fac table and catch output erros. in tMap i created a table X to put the erros for the first excel file. Now the same with the secod file but i can not add the erros in the same table i mean in the table X.pls let me know if u need more information.Thank you in advance Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now