Qdabra qRules

Re: Using CopyTable command with secondary data source table

Hilary Stoupa — Wed, 23 Oct 2013 21:38:57 GMT

With copy table, your source and destination must have the same number of elements (fields). So in your 2ds query, how many columns are there? If there are 5, you need 5 in your destination.

Re: Using CopyTable command with secondary data source table

TomRenfro — Wed, 23 Oct 2013 21:35:05 GMT

Ok, now I'm getting an error about source and destination must contain the same number of elements. So I assume by this that I can't load a subset of data with CopyTable? If not, is there another method where I can assign the row number of the records retrieved using a default value formula?

Re: Using CopyTable command with secondary data source table

TomRenfro — Wed, 23 Oct 2013 21:30:26 GMT

The proverbial snake would've bit me.

Thanks.

Re: Using CopyTable command with secondary data source table

Hilary Stoupa — Wed, 23 Oct 2013 21:28:14 GMT

You are missing the forward slash before the tabledest param.

Using CopyTable command with secondary data source table

TomRenfro — Wed, 23 Oct 2013 19:55:28 GMT

Hi,

I'm trying to copy a table from a secondary data source (populated using DBXL GetColumnsXMLStrQuery) from a SQL datatable into a repeating table in the main data source. When I right click on the group just before the repeating node, this is my XPath: /dfs:myFields/dfs:dataFields/tns:GetColumnsXMLStrQueryResponse/tns:GetColumnsXMLStrQueryResult/Rows. The XPath for the destination table is this: /my:myFields/my:group1/my:group2, group2 is the repeating section containing the discrete fields.

Here's my command: CopyTable /dsnamesrc=GetColumnsXMLStrQuery /tablesrc=/dfs:myFields/dfs:dataFields/tns:GetColumnsXMLStrQueryResponse/tns:GetColumnsXMLStrQueryResult/Rows /rowsrc=row tabledest=/my:myFields/my:group1 /rowdest=my:group2

I'm getting an error saying "Required parameter unspecified: tabledest. I don't see what's wrong. Please help.