Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]
Resident Clean1;
this is not working.
do you have an idea ?
Why not just:
LOAD IF([SalAccount]='N/A', [Corporate Account], [SalAccount]) as [Sales Account]
Resident Clean1;
Why not just:
LOAD IF([SalAccount]='N/A', [Corporate Account], [SalAccount]) as [Sales Account]
Resident Clean1;
thanks! much more simple
my whole script is
CleanUpMap:
mapping load * inline [
x, y
'LTD.', 'LIMITED'
'LTD', 'LIMITED'
];
Clean1:
LOAD Country,
[Corporate Account],
[Sales Account] as [Sal Account],
MapSubString('CleanUpMap',[Blg acc]) as [Billing Account]
Resident accountInfo;
LOAD IF([Sal Account]='N/A', [Corporate Account], [Sal Account]) as [Sales Account]
Resident Clean1;
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?