Splitting up into multiple CSV files based on column values then FTP
Hi,
I can see there's an option to split files up based on row counts, is it possible to split based on value(s) in a column (varchar, dynamic list driven from table)?
These values then will appear in file name also - ie. YYMMDD_RED.csv, YYMMDD_YELLOW.csv, YYMMDD_GREEN.csv - assuming colour is my column here that i want to split records into separate files, many records being red, yellow, and green.
As an aside, previous attempts to FTP I used FTP repository to specify credentials to put files on FTP. Is it possible to set this via contexts? - which can be set by values at database/file. I was slightly bemused when it came to password, as it didn't seem feasible to type in a context variable in here.
Regards,
John
Hi,
Can any one help me on this.
I am getting
"Preview Error. Some settings must be changed".
Below is the detailed error:
Exception in thread "main" java.lang.Error: Unresolved compilation problems:
com.talend cannot be resolved to a type
com.talend cannot be resolved to a type
com.talend.csv.CSVWriter cannot be resolved to a type
org.talend cannot be resolved to a type
org.talend cannot be resolved to a type
com.talend cannot be resolved to a type
com.talend cannot be resolved to a type
at bench1.shadowfileinputtodelimitedoutput_0_1.ShadowFileInputToDelimitedOutput.tFileInputDelimitedProcess(ShadowFileInputToDelimitedOutput.java:596)
at bench1.shadowfileinputtodelimitedoutput_0_1.ShadowFileInputToDelimitedOutput.runJobInTOS(ShadowFileInputToDelimitedOutput.java:1013)
at bench1.shadowfileinputtodelimitedoutput_0_1.ShadowFileInputToDelimitedOutput.main(ShadowFileInputToDelimitedOutput.java:894)
Preview error. Some settings must be changed.
Note: Preview errors are generally due to a wrong encoding setting.
org.talend.designer.runprocess.shadow.ShadowFilePreview.preview(ShadowFilePreview.java:90)
org.talend.metadata.managment.ui.utils.ShadowProcessHelper.getCsvArray(ShadowProcessHelper.java:383)
org.talend.repository.ui.wizards.metadata.connection.files.delimited.DelimitedFileStep2Form$PreviewProcessor.nonUIProcessInThread(DelimitedFileStep2Form.java:1309)
org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)
Hi, How to filter data dynamically during run time based on column and it's value?(I will give column name and it's value during batch file execution) Can any one share some suggestions on this? Regards, Asha
