Enhancement : "Insert column from external data” option doesn’t work when having 2 ondemand information link on same property control and column from one information link is inserted into another IL.

Enhancement : "Insert column from external data” option doesn’t work when having 2 ondemand information link on same property control and column from one information link is inserted into another IL.

Problem description (Steps to reproduce):

1. Created three tables in oracle database. For e.g: Customer , Company and Product.
2. Make sure you have one column called Customer id common in all the three tables with unique data in it. In my example , I have prepared scripts for inserting 1000 records in all the three tables for customer id ranging from 1 to 1000.You can create different relevant fields in the three tables as per your thinking.
3. Once done , set up data source in Information designer and create default information model for the three tables.
4. Load company table first in the spotfire professional client as your default or first table.
5. Create a text area and add a new drop down property control (document property) for customer id column from the company table.
6. Add first on-demand data table from Information link based on customer table and pass the input parameter to customer id column from the new document property created.
7. Add second on-demand data table from Information link based on product table and pass the input parameter to customer id column from the new document property created.
8. Manage/Create the relationship between the three tables based on customer id column(you can use manage relations button).
9. Apply “Insert column from external data” option to insert some columns in customer table from product table based on customer id matched column.

Now the main steps below to replicate the issue.

10. Now , when you change the drop down value , both the two IL’s (specific to on-demand tables) gets fired against the database to get the data.
11. But during this , “Insert column from external data” option doesn’t work as the source table(in this example product table) itself has no data and it’s in execution phase.(sql query getting executed at database level).Even the execution gets completed it doesn’t gets loaded.
12. As a result external column added to destination table (in this example customer table) doesn’t get the value allotted to it.
13. However , when you reload the analysis you will get the data displayed or allotted to the newly added column in the destination table (in this example customer table).

User wants the data to get loaded in the on-demand data table having “Insert column from external data” option applied.

TS-34539 Escalation task was raised and enginerring said that this is currently as designed.

Please consider this as future enhancement.