Hi, will try to explain myself better.
I added 4 tables to dataload manager. all their columns are exactly alike (bank statements for 4 different banks) so rightfully dataload manager joined them into one concatenated table:
However the first column which is a date in each of these tables, does not get recognized as a date. it is defined as general. Which is why the auto calendar does not kick off. I cannot edit the format to date because the format icon is not available. i assume this is because the tables are concatenated:
If i split the tables into 4 individual ones I can edit the format of the date column into date but then how do I re concatenate these tables again? I want them to be considered one and not 4.
I tried the association feature but it only lets me associate one column per 2 tables at the time. if i try to add another association, it breaks the first one (e.g. if i associate the dates between 2 tables and then try to associate the income column between them, it breaks the date association).
I know there is more flexibility in dataload editor but once I unlock it there is no going back and i am really not comfortable with scripting so would like to stay with dataload manager available.
Is there a way to "tell" dataload manager that my date column contains dates without splitting the tables? or if i have to split them, how can i concatenate them back?