Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
GuptaN
Contributor
Contributor

Drop added new column after functionality complete

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

 

Labels (1)
2 Solutions

Accepted Solutions
lyka
Support
Support

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/Custom...

 

Thanks

Lyka

View solution in original post

SwathiPulagam
Support
Support

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

View solution in original post

5 Replies
Heinvandenheuvel
Specialist III
Specialist III

@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.

 

lyka
Support
Support

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

GuptaN
Contributor
Contributor
Author

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

lyka
Support
Support

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/Custom...

 

Thanks

Lyka

SwathiPulagam
Support
Support

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