E9.2 Passing Variable from Data Request to be used in a filter in another Data Request

[notchy]

Hi all,
I have a simple requirement to get the short item # (F4101.ITM) using 2nd Item number (F4101.LITM) in a Data Request and then use the (F4101.ITM) value as part of the filter in another Data Request filter that needs to use the (F4101.ITM).

The users only know the 2nd item No. and the table that I need to retrieve data from, only has alias (ITM) available to filter on.

In short of creating a custom business view to get around this, I know this can be done with the data request passing variables but when I am testing the 1st Data Request on the F4101 it is successful but the 2nd call fails and if I default in the ITM value in the second Data Request records are fetched.

Here is my setup and the variables I am using in the screenshot. Is there anything that sticks out that I am doing wrong?

 

[lfurino]

You should remove the ${} around the output variable of the first data request. You should only need the variable name there.

 

[DaveWagoner]

Hi notchy, this one is much easier than you think!

In the Return Fields section of the first request, you shouldn't put a "replacement var" styled ${varname} there. Just put a simple text field such as Short Item No. Then, that should become available in the transformation of the next data request for mapping into ${Short Item No 1} which shoudl show up in transformations as just "Short Item No 1".

Hope that's helpful

EDIT: I see @lfurino beat me to the punch and in far fewer words!

 

[notchy]

That has seem to do the trick. Thank you @lfurino and @DaveWagoner .