1. thank you for using tags

2. read the link that plegall sent you in your last topic ([Forum, topic 4103] Jessica BEGS FOR YOUR HELP :().
specifically these sections:

Use a descriptive thread title.
We ask you to follow these simple guidelines.
Be sure to include a brief description of your issue or question in the title of your thread. This will help other users understand what you need and avoid clicking on threads in which they have no interest.
Examples of unacceptable thread titles:
   "Help!"
   "Problem"
   "What Should I Do?"
Examples of acceptable thread titles:
   "Execute shell script"
   "Contexts & Email Attachments"
   "As400 connection problem"

Don't write IN ALL CAPITALS BECAUSE IT MAKES IT VERY DIFFICULT TO READ AND APPEARS LIKE YOU ARE SHOUTING. It is proven that proper case English is easier to read because it flows easier. All capitals is also proven to invoke a negative feeling towards the poster.

Be polite
The support given on the forums is for free (except for the well paid guys at Talend, of course) so please be polite. Although your particular problem may be important to you, it will most definitely NOT be important to the majority of forum readers. Therefore, be gracious and request help in a polite manner. It's not that we expect anyone to crawl or plead, but your tone is more likely to appeal to those who would lend a helping hand.

and remember

You don't need to make obvious you're a girl, young and under pressure from your boss to get helped from Talend community :-) By the way, not only guys can help you.

and try using a tMap, with multiple output tables.  you'll have to drag your columns over in the groups you want to each output table, but then it will be set up.

Last edited by strpdsnk (2008-09-13 00:36:12)

Jessica_girl wrote:

oh my god here are all beginners. when i post a topic, always are the answers like this: "Clarify your problem etc."

It's perfectly OK to be a beginner concerning Talend softwares but it doesn't mean you can also be a beginner in communication. Introducing your problem with clarity encourages community members to help you (but saying you're a 23 years old girl doesn't).

Jessica_girl wrote:

I wont use talend anymore. Talend open studio is an useless program!!!

It's not because you don't use it that's it's useless. Coming on the project community forum and saying such words won't encourage the community to help you.

and the only way i can figure out to get the list of columns in groups by # is this (at least in MSSql), but i don't see how that will help you with your problem... unless you first did a query to get the columns and then concatenated all the column names (from the query below) together and put that into a following DB component... lemme see if i can make that work

select t.name, c.name, c.column_id
from sys.tables T
left join sys.columns C on t.object_id = c.object_id
--where t.name = 'tblTask'
order by t.object_id, c.column_id

yea, you can pull the list of columns that way and use them in a query, but then you're going to run into issues with set up schema.

i would say do a query on your whole table, connect it to a tMap and split your columns up into different output chunks that way

Last edited by strpdsnk (2008-09-13 20:15:50)