Reltio Connect

Hi Team,

We have a scenario where a entity contains 10 attributes and the user is trying to export it in a column order.
Example - 
Attribute present in entity - A, B, C, D, E, F 
export needed in this format - C, D, E, A, F

Currently we can able to re-order in Ui, but in export it gets order in A, B, C, D, E, F order.
Can we achieve the order way attribute to be exported.

------------------------------
Chetan P
Freshworks
------------------------------

Hi Chetan,

Sorry for the delay.  I believe this is possible with the ROCS Data Extract Utility which can be found here: Bitbucket

Bitbucket		remove preview
Bitbucket View this on Bitbucket >

 

Alternatively, you can use any ETL tool to change the order from the default extract to the order that you need via post-processing.

------------------------------
Gino Fortunato
Senior Solution Engineer
Reltio
------------------------------

Original Message:
Sent: 02-17-2022 02:32
From: Chetan P
Subject: Export order in columns

Hi Team,

We have a scenario where a entity contains 10 attributes and the user is trying to export it in a column order.
Example - 
Attribute present in entity - A, B, C, D, E, F 
export needed in this format - C, D, E, A, F

Currently we can able to re-order in Ui, but in export it gets order in A, B, C, D, E, F order.
Can we achieve the order way attribute to be exported.

------------------------------
Chetan P
Freshworks
------------------------------

Hi Gino, 

Thanks for the response, I had a look onto the Bitbucket link.
Can we have query filter while exporting during export via Bitbucket.

Kindly help me on this.

------------------------------
Chetan P
Freshworks
------------------------------

Original Message:
Sent: 02-28-2022 09:02
From: Gino Fortunato
Subject: Export order in columns

Hi Chetan,

Sorry for the delay.  I believe this is possible with the ROCS Data Extract Utility which can be found here: Bitbucket

Bitbucket		remove preview
Bitbucket View this on Bitbucket >

 

Alternatively, you can use any ETL tool to change the order from the default extract to the order that you need via post-processing.

------------------------------
Gino Fortunato
Senior Solution Engineer
Reltio

Original Message:
Sent: 02-17-2022 02:32
From: Chetan P
Subject: Export order in columns

Hi Team,

We have a scenario where a entity contains 10 attributes and the user is trying to export it in a column order.
Example - 
Attribute present in entity - A, B, C, D, E, F 
export needed in this format - C, D, E, A, F

Currently we can able to re-order in Ui, but in export it gets order in A, B, C, D, E, F order.
Can we achieve the order way attribute to be exported.

------------------------------
Chetan P
Freshworks
------------------------------

Hi Chetan,

I don't see that in the bitbucket documentation, either.  It seems that the console export should be able to do export with column order and a 'where' clause.  However, it's not documented in enough detail to be sure.  You can raise a support ticket or do the post processing suggested earlier.


------------------------------
Gino Fortunato
Senior Solution Engineer
Reltio
------------------------------

Original Message:
Sent: 03-19-2022 10:16
From: Chetan P
Subject: Export order in columns

Hi Gino, 

Thanks for the response, I had a look onto the Bitbucket link.
Can we have query filter while exporting during export via Bitbucket.

Kindly help me on this.

------------------------------
Chetan P
Freshworks

Original Message:
Sent: 02-28-2022 09:02
From: Gino Fortunato
Subject: Export order in columns

Hi Chetan,

Sorry for the delay.  I believe this is possible with the ROCS Data Extract Utility which can be found here: Bitbucket

Bitbucket		remove preview
Bitbucket View this on Bitbucket >

 

Alternatively, you can use any ETL tool to change the order from the default extract to the order that you need via post-processing.

------------------------------
Gino Fortunato
Senior Solution Engineer
Reltio

Original Message:
Sent: 02-17-2022 02:32
From: Chetan P
Subject: Export order in columns

Hi Team,

We have a scenario where a entity contains 10 attributes and the user is trying to export it in a column order.
Example - 
Attribute present in entity - A, B, C, D, E, F 
export needed in this format - C, D, E, A, F

Currently we can able to re-order in Ui, but in export it gets order in A, B, C, D, E, F order.
Can we achieve the order way attribute to be exported.

------------------------------
Chetan P
Freshworks
------------------------------