column selection using data from sql server.

[sbatra116]

Hello,

Newbie here. 

Flow:  I want my column selection based using data from sql server. 

I'm passing 3 fields from sql server as column name, those will be fetched from larger spreadsheet.

once i have the columns those need to pass into Macro for further processing.

Flow:

Speadsheet has say 9 columns

A	B	C	D	E	F	G	H	I

sql server pass 3 columns 

A

B

C

select A, B and C from spreadsheet.  - complete (used Transpose function)

Pass these to Maco which accepts 3 input.  (Issue here)

i have to assign macro inut with column names, but how to handle once my sql server pass other columns like d,e,f insread of a,b,c

Question:  how do i dynamically select columns from spreadsheet depending upon values passed from sql server and pass those to marco.

[ddiesel · Accepted solution]

Hi @sbatra116!

One approach would be to utilize the "Only Output Common Subset of Fields" mode in the Union tool. The only tricky part is bringing your column names up to the header row. This can be accomplished with the RecordID, Cross Tab, and Dynamic Rename tools.

If you need help configuring this into your macro, please upload your workflow or post screen shots so we can advise.

Let us know if this works for you!

Thanks,
Deb

[sbatra116]

thank you ddiesel.

works for me