How to Show "Other" in Mapping

[#1]

Hi All,

I would like to ask you about mapping in QV,

I have QVD files that I connect with the txt file, and I mapping  by using an excel file.

But I Can not show item in "CORE_BRAND" because the source is empty, so i wanna show it with "OTHER" if the source is empty.

I enclose the QVD, txt and excel file.

Please help me to show it.

[awhitfield]

Hi Ted,

I still can't open the file, just send  over the Mapping load and Applymap statement you're using

Andy

[#3]

Hi Shiva,

i have enclosed in attachment, but thank you. i have solve the problem with your suggestion. Thank you.

Best Regards,

Ted

[buzzy996]

ur wc