Some possible ways:
- Load the value from DBMS as requested, hard to tell how you should do this with the information provided
- Use a conditional in your LOAD script
LOAD If(FIELD, 'Yes','No') as FIELD;
SQL SELECT FIELD FROM Table;
- Use a mapping approach
I tried mapping many times but failed there was no difference. I believe I did something wrong all the time but can't see where. Maybe I should share the document.
It shows number but I want a text inside of that two fields.
Formxx.qvw 426.5 K
unfortunately, your QVW does not show much. It just does a binary LOAD and a rename of fields, no attempt to map or transform your value.
Attached is an example how you can use a mapping table to transform your values to dual values showing a text, like
LOAD IN, Dual(OUT,IN) as OUT INLINE [
LOAD ApplyMap('MAP',Cinsiyeti) as Test RESIDENT "[PER002]";
Formxx_2.qvw 432.5 K
I found (thanks to you) a solution right after wrote you 2 days ago . Its was not a good solution by the way but it helped me.
My solution is : because of its binary, I couldnt do anything about mapping. So I sent to excel which datas I wanted to change, took a qvd from that then I did the mapping technique, that's all.
Thanks for your help Stefan.