dynamic select according to field name

[talc_87]

Hi

How can I perform a dynamic select according a spreadsheet which is entered by the user?

I have 2 tables

Table 1, contains financial data of public companies. The table is on Azure DB.

symbol	cash	revenue	expenses
AAPL	xxx	xxx	xxx
AMZN	xxx	xxx	xxx

The user will input an Excel spreadsheet which details the symbols and the filed he like to extract from table 1

For example:

symbol	field
AAPL	revenue
AAPL	expenses

The workflow will extract records for the relevant record for the symbol.

You can change the user template anyhow you want.

How do I perform the dynamic select of the fields?

I cannot use transpose tool, since the dataset is very big .

Thanks, Tal

[atcodedog05]

Hi @talc_87 

Here is how you can do it.

Workflow:

Hope this helps : )

[messi007]

@talc_87,

Please see below :

Attached the workflow,

Regards,

[talc_87]

Can we do it without the transpose? as I said it will take to much time...

[atcodedog05 · Accepted solution]

Hi @talc_87 

Here is the dynamic rename and select method should be faster

Workflow:

Hope this helps : )