Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can someone help me to pick common value and create new field in load statement
EX:
account1=account2
Account1 | Acount 2 | NewField |
---|---|---|
1 | 1 | 1 |
2 | 3 | 3 |
3 | 5 | |
4 | 7 |
How did you get 3 for row number 2 under NewField? In row 2 Account1 <> Account2
compare two fields and get common values only
Ex: 1 and 3 values only common
looking like this:
if(Account1=Account2) as new field
If(Account1 = Account2, Account1) as NewField
Here is a concept that might get desired results but i wouldnt recommend this on huge data set. You would have to evaluate if this fits your needs, i have separated columns and loaded them in two different tables , and looked up values, Its a simple script so hopefully not much of explanation needed here
Here is info on lookup function:
Accounts:
Load * Inline [
Account1
1
2
3
4
] (delimiter is '|');
Accounts2:
Load *, Lookup('Account1', 'Account1', Account2 , 'Accounts') as NewField
Inline [
Account2
1
3
5
7
] (delimiter is '|');
Let me know what you think.
Hi Karen,
Does this answer your question?
Thanks,