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 etl
after evaluating the sql in the dataset and query window, the fields will be added to the table element.
- double click on the table element
- expand 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