Data Services nest and unnest produce input ^2 records

[holger_blum]

Hi,

I need to call a SAP RFC function with table input parameter

to call the function, I create a new schema in my query based on my input table ( 5 records ) and pass this to SAP function.

when I start the dataflow, the output creates 25 records ( 5^2 )

I delete the function and unnest the nested query 20, same result, 25 records...

What is the problem?

Thx for your help

Holger

[Julian_Riegel · Accepted solution]

Hi Holger,

when working with NRDM Schemas with a flat input you always need to use a Row_Generation Transform to build the head of the Schema. Otherwise you will build cartesian products.

Try Funneling in a Row_Generation into your "Query_20" which creates only one row. Within the "Query_20" where you set up your Nested Schema, double click the "Query_20" Schema and there in the From Clause only select the Row Generation. Then double click into "IT_TABLES" and select your "Query_10" in the From Clause.

This should give you your desired output. To test things, you can use a "Nested Schema Template" from the DS toolbar on the right as output. This should create you an .xml file at the defined target location where you can check the structure of your output.

It should look something like this:

BR,

Julian

[holger_blum · Accepted solution]

Great, you save my day 🙂