topic Re: Drop added new column after functionality complete in Qlik Replicate

Drop added new column after functionality complete

GuptaN — Wed, 23 Mar 2022 09:00:48 GMT

Created one new column for changing datatype after that create one column for performing some operation.

I tried to drop first created column by global transformation but not worked.

Please guide on this.

Regards,

GuptaN

Re: Drop added new column after functionality complete

Heinvandenheuvel — Wed, 23 Mar 2022 14:05:52 GMT

@GuptaN place yourself in the position of the folks reading your post and trying to help. Now re-read your post as if someone else wrote it. Could you even start to help? It's a terrible post! No details!

"I tried to drop first created column by global transformation " - show us that transformation! NOT (only) as a picture, but as a partial code snippet from the task JSON export.

"not worked" - was there a (error) message? What steps did you take to verify it 'not worked'? Specifically did you force a reload with drop + create on

"Created one new column for changing datatype after that create one column for performing some operation." - show us that transformation! NOT (only) as a picture, but as a partial code snippet from the task JSON export.

Please help us help you by providing detailed problem descriptions.

Hein.

Re: Drop added new column after functionality complete

lyka — Wed, 23 Mar 2022 17:20:49 GMT

Hi Gupta

Please provide more details on your use case.

What type of transformation are you trying to do and what are the operations.

Thanks

Lyka

Re: Drop added new column after functionality complete

GuptaN — Mon, 28 Mar 2022 16:30:50 GMT

How to drop custom column in qlik replicate ?
Please guide me for this

Re: Drop added new column after functionality complete

lyka — Mon, 28 Mar 2022 16:39:13 GMT

Hello,

You can remove the column from Replicate via the transform tab.

Go to Designer > highlight the table > table settings > transform

On the output columns, highlight the column you wish to remove and select <

https://help.qlik.com/en-US/replicate/May2021/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_useTransTable.htm

Thanks

Lyka

Re: Drop added new column after functionality complete

SwathiPulagam — Mon, 28 Mar 2022 16:41:31 GMT

Hi @GuptaN ,

Since you created a column using Global Transformation, the column will exist only on the target side so you have to manually drop the column after removing the Global Transformation from the task.

Thanks,

Swathi