Creating a macro

[Komal_]

Hello Everyone,

I have a below use case and the result am trying to build - 

USECASE - 

1. Build a macro, which should filter input data (below is how my input data sample), based on the options selected from drop down using drop down interface tool

FILED_NM	FILED_VAL	INPUT_QUERY
COUNTRY	INDIA	SLEECT * from abc.xyz;
EXCHNAGE	INDIAN EXCHANGE	SLECTE * from abc.cde;

2. If in the drop down I select EXCHANGE, then the dynamic input tool must read the INPUT_QUERY and fetch me the data from respective table (e.g. SLEECT * from abc.cde, if EXCHANGE is selected and SELECT * from abc.xyz, if COUNTRY is selected)

3. Below is the structure of both the tables - 

SELECT * from abc.xyz - 

ABC_COUNTRY_NAME	ABC_COUNTRY_CODE	DATE	NAME
INDIA	IN
AFGANISTAN	AF
ALBANIA	AL

SELECT * from abc.cde-

ABC_EXCHANGE_NAME	SID	GROUP
INDIA EXCHANGE
AFGANISTHAN_EXCHANGE

4. In case of any selection (whether COUNTRY or EXCHANGE), the table columns which contains "ABC" in their filed name must be renamed to FILED_VAL and the data from Input data FIELD_VAL should be joined and looked up with tables "FILED_VAL"

5. Once this macro is build, this would be used in another analytical app or workflow, where the input data would change but the same functionality should be performed.

Request if anyone could help me develop this.

Thanks in advance,

Komal