Test Data Manager

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

When trying to refer to another column value from another table in Datamaker , getting error as "Go back and edit the data "

  • 1.  When trying to refer to another column value from another table in Datamaker , getting error as "Go back and edit the data "

    Posted Dec 18, 2023 12:14 PM

    Hi Team,

    I have a Table A and Table B in same DB and Datamaker connection profile . And I have RefTable in separate connection profile. I have to patch ID column value in Table B with that value present in RefTables' s MaskId Column where RefTable's  Id  and Name Column = Table A's Id and Name Column

    So, in Datamaker to achieve this I am using below query, which throws error as Table not open-

    Query used in Datamaker

    @execsql(Pmytesting ,SELECT MaskId FROM [dbo].[RefTable] WHERE Name= '^TableA.Name(n)^' and Id= '^Id^')@

    In above query-

    • mytesting is name of connection profile where RefTable is kept.
    • Name column of RefTable is compared with Table A's Name column in Where clause
    • ID column of RefTable is compared with table B's own ID column, where we are writing the Datamaker query.
    • And then based on above criteria matching ID Value from Ref table is fetched and patched into Id column of table B

    1- What should be the value of n here ??

    2. Getting error as "Go back and edit the data".