Passing different fields to SELECT statement in Dynamic Input

monish_chandra

I'm using Dynamic Input to pass column names from a Text input. Seems like Dynamic Input tool doesn't handle different schemas. The column names are passed to a dynamic Input tool and I''m using Replace a specific string to modify the SQL statement.

The SQL statement is as shown below

SELECT 'col_names'
FROM CLAIMS
WHERE MbrId='12346678'

Using the Replace Specific string, I'm changing the select criteria i.e 'col_names'

It gives me the following error

Dynamic Input (13): The file "" has a different number of fields than the 1st file in the set and will be skipped

Input:

ID	Select_fields
1	Mbr_Id, ProcedureCD
2	Mbr_Id, ProcedureCD, Claim_Nbr

Expected Output

ID	Mbr_Id	ProcedureCD	Claim_Nbr
1	12346678	ABCD
2	12346678	ABCD	34895

DynamicInput_Columns.yxmd

Claje

Hi,

You've correctly identified that the dynamic input tool doesn't handle different schemas.

The workaround to this is to encapsulate your Dynamic Input tool inside of a batch macro, and to configure that macro so that its output schema can change by iteration.

I've attached a quick example - you'd just need to update this macro to use your query template.

Let me know if you have any questions, and take a look at the batch macro input configuration in my attached workflow.

claje_DynamicInputColumns.yxzp