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

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

column selection using data from sql server_dmd.yxmd