idea Re: Rename Change Table Header Columns in QLIK replicate in Suggest an Idea

Rename Change Table Header Columns in QLIK replicate

NikolayYelevich — Wed, 27 Apr 2022 18:54:09 GMT

Re: Rename Change Table Header Columns in QLIK replicate

john_wang — Thu, 28 Apr 2022 03:14:23 GMT

Note sure what's the target endpoint type.

If it's a relational database then a VIEW in target side DB maybe a workaround, the view will decouples the Replicate __ct table Header Columns name and your consumer Apps. Anyway, let's wait for PM Team final response.

Regards,

John.

Re: Rename Change Table Header Columns in QLIK replicate

bobvecchione — Tue, 03 May 2022 11:38:30 GMT

We are not planning to change the headers as a feature request. Johns suggestion is a good one.

Thanks for your submission

Bob V

Re: Rename Change Table Header Columns in QLIK replicate

NikolayYelevich — Fri, 06 May 2022 13:53:43 GMT

Bob and John,

thank you for your respond. Unfortunately using views in database will severe affect application performance...We are looking possibility to recognize "image before" and "image after" rows when we use change tables. Unfortunately only header columns (change_oper and operation) provide this info. When we are trying to add column to change table via TRANSFORM menu and use $AR_H_OPERATION - "image before" information is not present in this column. Our application partners require us to have an particular name for "operation" column. Choice we have :

1. Rename header column which contain need info.

2. Modify "$AR_H_OPERATION" header to provide information similar to change_oper or operation headers.

Please advice.

Regards

Nikolay Yelevich

Re: Rename Change Table Header Columns in QLIK replicate

john_wang — Sat, 07 May 2022 03:28:58 GMT

Hello @NikolayYelevich ,

If you use $AR_H_OPERATION in transformation then the result will present after image of the operation only. (you cannot get "B", or "BeforeImage").

Anyway I do not see how a view impacts performance. Can you explain more about that.

thanks,

John.

Re: Rename Change Table Header Columns in QLIK replicate

Prabodh — Wed, 18 May 2022 19:38:10 GMT

You can also specify a prefix to all the header columns. We use that.

Re: Rename Change Table Header Columns in QLIK replicate - Status changed to: Open - New

Nulee_Massaro — Tue, 13 Sep 2022 12:52:08 GMT

Could you please provide us with details of a use case of why you would want to change the column names? Thank you!

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 16:15:53 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Rename Change Table Header Columns in QLIK replicate - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 16:15:55 GMT