Focal Point
[CLOSED] Dynamic columns data modification

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9857094096

July 06, 2018, 11:37 PM
Sandhya j
[CLOSED] Dynamic columns data modification
Hi,
I have a requirement to modify/remove invalid data in dynamic columns Result Set. As I don't know the Data Type of column how can I achieve this functionality?

Thanks
Sandhya

This message has been edited. Last edited by: FP Mod Chuck,


WEBFOCUS 8202/Windows
PDF/HTML/XML
July 07, 2018, 12:52 AM
pav
Hi,
Can you please provide some more information on this.
July 07, 2018, 07:38 AM
Sandhya j
Hi,
MY Stored Proc returns varied number of columns (depends on the user selection). It can have min 1 column to maximum 50 columns in the output.
Order also can change.
Once I read data into webfocus table, I need to modify data in some columns. For ex: I might have date columns in the output. I need to check invalid dates and replace it with blank.
For this purpose I need to know data type of column (A/I/D etc.). How can I get it?

Thanks
Sandhya


WEBFOCUS 8202/Windows
PDF/HTML/XML
July 07, 2018, 11:27 AM
pav
https://webfocusinfocenter.inf...ang/source/dif42.htm

Try this once, might be helpful.