topic Give a client a value based on if-statement in Connectivity & Data Prep

Give a client a value based on if-statement

NielsCoolen — Wed, 14 Jul 2021 08:12:17 GMT

Hello everyone!

I have got a client and he's got multiple types of addresses (home address, postal address, invoice-address, etc.).

My data looks like this. It is the Client_Adresses table:

Client	Address Type	Address
Mr. Adams	A	Street 1
Mr. Adams	C	Road 2
Mr. Adams	D	Lane 5
Mr. Smith	B	Lanestreet 3
Mr. Smith	C	Mainroad 2
Mr. Smith	E	Path 1
Mr. Richards	A	Avenue 3
Mr. Richards	D	Pathway 7

In a different Client-table, I just want to maintain 1 address for each client. Where I make use of an if-statement to figure out which address is the 'default address' to use.

E.g. if client has type A then use type A as default address. Else, if client has type C, use type C as default address. Else, if client has type B, use type B as default address. And so on, and so on.

But I'm trying to figure out how to script this.
Can anyone give me any pointers? What are useful functions?

Thank you so much in advance!

Re: Give a client a value based on if-statement

PrashantSangle — Wed, 14 Jul 2021 08:25:19 GMT

one query. in above sample data one client have both type of address then which type is default address you want to give??

Re: Give a client a value based on if-statement

NielsCoolen — Wed, 14 Jul 2021 08:32:39 GMT

I have a logic in my mind. Some clients have all types of addresses and some only have 1 or 2.

I want to give each client 1 default address, based on the logic I have in my mind:

if(Client has Type A, Type A, else if(Client has Type C, Type C, else if(Client has Type B, Type B, else if(Client has Type E, Type E, Type D))))