Discussion Board for collaboration on QlikView Scripting.
If field SalAccount is 'N/A', i would like to have it replaced by the value of field Corporate Account, else leaved unchanged. I have written this script
LOAD IF([SalAccount]='N/A', Replace([SalAccount], 'N/A', [Corporate Account]), [SalAccount]) as [Sales Account]
this is not working.
do you have an idea ?
Go to Solution.
Why not just:
LOAD IF([SalAccount]='N/A', [Corporate Account], [SalAccount]) as [Sales Account]
View solution in original post
thanks! much more simple
my whole script is
mapping load * inline [
[Sales Account] as [Sal Account],
MapSubString('CleanUpMap',[Blg acc]) as [Billing Account]
LOAD IF([Sal Account]='N/A', [Corporate Account], [Sal Account]) as [Sales Account]
Clean up in Clean1 is performed, but not the one in the LOAD IF
You need to post data and a .qvw along with an explanation of what you're getting vs. what you're expecting to get if you want more help with this.
data are confidential and would need rework before post. thanks anyway
Take a look at this post. It will help you to figure out what you can do to your document in order to post it on here while keeping your data confidential: Preparing examples for Upload - Reduction and Data Scrambling
I also suggest you read through this post thoroughly: QlikCommunity Tip: How to get answers to your post?