ContributionsMost RecentMost LikesSolutionsHow to count the columns in table Hi Team, I'm pulling data from the source system which have "n" columns, I wanted to count the number of columns that I'm getting from the Source System. So that to map them with the respective Target System. Please help me out this, Thanks in advance. SolvedRe: How to count the columns in table Thank you j_angelevski Re: How to count the columns in table Hi j_angelevski Source System: Workday Prism Target System: SAP Concur Pulling Data from WDPrism via web service and pushing in to SAP Concur. While pulling data I'm getting few fields "Status", "Header', "Entity", "_debug". In " entity " I have the reqiured data. In Which there are 137 fields that I need to Map and transform in to excel table. Mapping and transformation in to excel is done. But columns having NULL value should be replaced by Blank value. Can u help me out this. Bcz among 137 fields or say as excel columns I have almost 70+ NULL values in the in each record. Thanks Manzoor. Re: How to replace the fields having "NULL" and write as Blank I.E " " Thanks j_angelevski How to replace the fields having "NULL" and write as Blank I.E " " Hi team, There are few fields where I'm having value as NULL, I want to make NULL in to blank, in all the Fields where I have the NULL. Help me in a way so that I can write a logic which can replace all the NULL in to Blank. Thanks in Advance. SolvedRe: Configuration of OpenFT to SnapLogic System OpenFT is a high-performance solution for complex heterogeneous IT organizations. Files are automatically transferred with openFT – with full security thanks to data encryption. Typical file transfer be upgraded to a managed file transfer that is worthy of being called a secure file transfer – and which also supports the FTAM protocol. Follow this link for more details : https://www.fujitsu.com/global/products/software/partners/oracle/openseas-oracle/open-ft/ Configuration of OpenFT to SnapLogic System How to connect OpenFT to the SnapLogic system. What are the details that are required and how they are configured…?