Qdabra qRules

Re: Moving data from a secondary repeating table into a primary repeating table.

Elfanger — Wed, 26 May 2010 22:29:30 GMT

Thanks. I will give it a go.

Re: Moving data from a secondary repeating table into a primary repeating table.

Hilary Stoupa — Wed, 26 May 2010 16:56:02 GMT

Hi -- I moved your question to the qRules forum -- it looks like you are using qRules.

The qRules copy and move table commands require that the source and destination have the same number of fields. I'm wondering if a possible workaround might be to add some columns to your SharePoint data connection, then, after you move your table, set those fields to blank in the main data source table. So, for example, if you were moving or copying the data from a SharePoint data connection that only selected 3 fields from the list (like Title, Status, Modified By, for example), you could modify that data connection to select some other list columns that have data you don't need, just so that your column count was the same. Perform your move table operation, then in the columns where you copied data you don't really need, you can use rules to set those fields to blank....

Re: Moving data from a secondary repeating table into a primary repeating table.

Elfanger — Wed, 26 May 2010 05:39:26 GMT

I need to add some more fields to the repeating table. It does not let me add any extra fields to the secondary table, that is why I thought I should transfer from secondary to primary.

Re: Moving data from a secondary repeating table into a primary repeating table.

Qazi Anis — Wed, 26 May 2010 05:21:39 GMT

you can use the data from the secondary data source, no need to move it to another repeating table. Can you let me know why exactly you want it to be moved to the repeating table. I think you should be able to achieve your functionality by using the secondary connection directly

Moving data from a secondary repeating table into a primary repeating table.

Elfanger — Wed, 26 May 2010 03:36:48 GMT

I am trying to move date from a secondary repeating table (which gets its data from a SharePoint list) into a primary repeating table so that it can then be used.

There is just 1 column of data being imported from SharePoint. When I setup the primary repeating table with just 1 column, it transfers properly. However, I need some extra columns in the primary table. When I created these extra columns, the move function would no longer work.

This is the code that I have used:

MoveTable /dsnamesrc=EquipmentChecks /tablesrc=/dfs:myFields/dfs:dataFields /rowsrc=dfs:Equipment_Checks /tabledest=/my:myFields /rowdest=my:PrimaryChecks /empty=no

Does anyone know of a workaround for this situation or a better way of doing it altogether?

Thanks.