Is it possible to remove columns on an information link before loading data (without having access to information designer)

[Shubh M]

Hello

I am under this scenario, where I am looking to remove some columns while loading an information link. for example, there are 10 columns in the information link and I only need 7 of them. the other 3 columns bring a lot of data, which I am not interested in. I dont have access to information designer at the moment.

Any way this is achievable. Many thanks in advance.

 

Regards

Shubs

[Shashank Gurnalkar]

Hello Shubham,

To edit/modify the structure of an Information Link, you need to have access to the Information Designer. So with your current access permissions, I don't think you can remove the column elements of the Information Link.

[Shubh M]

Thanks Shashank for your answer. 

 

How about an IronPython script to add a data table with a Pivot transformation any such thing

 

http://informatics.perkinelmer.com/Support/KnowledgeBase/details/DefaultTechNote=3226

 

 

 

Thanks

 

Shubham

 

 

[Shashank Gurnalkar]

I am not sure how this is going to help you to achieve your use case. Even if you try to Pivot the data, it will bring all the data first (including unwanted columns) and then Pivot operation will get performed on the data.