LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Bryt Park

Hi

I need to pull some fields from multiple sources/files and then piece these field into one record.

Each source contains ONLY ONE single record (the records are generated by multiple independent complicated VBA programs, not in LavaStorm)

However, there are no common fields among these source files, so Join would probably not work.

I tried Cat node, but it does not piece the fields into one single record, please kindly advise.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

There are several ways to accomplish what you want.. two methods are included in the attached graph.
Attachments:
MergingColumns.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Bryt Park

Hi Stonysmith

Thanks for looking at this, I need to extract 2 - 3 fields from 13 difference sources, so the first approach where Cat node is used would be more appropriate for me.


However, the node you posted only spit out the first column of each source file, how do I get it to spit out multiple columns from the source file?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ryeh

Modified the two examples above to include more fields. I personally think the second approach is "easier" to implement as it requires less scripting. But the first approach has a cleaner feel to it.
Attachments:
MergingColumns.brg