| Author |
Message |
 Topic: Parsing select columns from a CSV |
BHill
Replies: 11
Views: 9477
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Fri Aug 26, 2016 2:05 pm Subject: Parsing select columns from a CSV |
Ok, thanks mqjeff, and everyone. I appreciate it.
It looks like I should just parse it all out as arrays (header arrays, and row arrays) and sort out the columns I want in eSQL or possibly a comput ... |
| Topic: Parsing select columns from a CSV |
BHill
Replies: 11
Views: 9477
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 25, 2016 10:37 am Subject: Parsing select columns from a CSV |
No, the header has the same column count as the rows. No nightmare there.
I just need to sift through the header to find the desired columns, and then translate my knowledge of which columns contai ... |
| Topic: Parsing select columns from a CSV |
BHill
Replies: 11
Views: 9477
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 25, 2016 10:13 am Subject: Parsing select columns from a CSV |
| Thanks shanson. That's what it looked like to me. Given that I know what text I am looking for in the header items, I think I can setup a choice that matches the value to an expected string. That woul ... |
| Topic: Parsing select columns from a CSV |
BHill
Replies: 11
Views: 9477
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 23, 2016 6:40 pm Subject: Parsing select columns from a CSV |
I'm currently looking at just ingesting everything as <title> and <item> arrays, and then sorting out the desired columns and data in eSQL. Maybe this is what you meant.
There may be m ... |
| Topic: Parsing select columns from a CSV |
BHill
Replies: 11
Views: 9477
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 23, 2016 2:49 pm Subject: Parsing select columns from a CSV |
So far, I've had no luck in figuring out how to get DFDL to identify columns by names.
The default IBM example for ingesting CSV files with headers expect a fixed number of columns and then just a ... |
| Topic: Parsing select columns from a CSV |
BHill
Replies: 11
Views: 9477
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 23, 2016 7:23 am Subject: Parsing select columns from a CSV |
| Ok, thanks. I'll give DFDL another go. I'll try importing the CommaSeparatedFormat.xsd schema after reading the header. Doing so beforehand gives me complaints about using an occursCountKind of 'parse ... |
| Topic: Parsing select columns from a CSV |
BHill
Replies: 11
Views: 9477
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 18, 2016 8:16 pm Subject: Parsing select columns from a CSV |
I've search through the forums and I don't think I've seen anyone ask about this. If this is a repeat, I apologize.
I get a CSV file with a header that needs to be inserted into DB2. If the column ... |
